question archive 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
Purchased 7 times