question archive Sale amounts (Cost) of $1000 and over earn 5%

Sale amounts (Cost) of $1000 and over earn 5%

Subject:AccountingPrice:2.86 Bought7

Sale amounts (Cost) of $1000 and over earn 5%.

Sale amounts less than $1000 but more than $500 earn a commission of 2%.

Sale amounts less than $500 do not earn a commission.  

What is an IF excel function that will satisfy these 3 constraints

 

Option 1

Low Cost Option
Download this past answer in few clicks

2.86 USD

PURCHASE SOLUTION

Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 7 times

Completion Status 100%