How to create a formula 5 to 10% based on given list of price
 

I am given a of price of cars sold by a sales agent of automobile company. I
am to work into excel to solve this question. The commision he gets is varies
from 5 to 10%. Can you please make a suggestion to guide me? Thanks a lot for
your attention.


Candy

How to create a formula 5 to 10% based on given list of price
 

This is a start:
=IF(AND(A1=10000,A1<=20000),A1*15%,IF(AND(A12000 0,A1<=25000),A1*10%,"Your
Entry"))
Reads as follows: If the price greater than 10000 and less than or
equal to 20000 the A1 (which is the price of the car)*5%, If A1 greater
than 20000 and A1 <=25000, then A1*10%.
Select an IF Function and then select the AND function - when you close
the "AND" function you will get an "ERROR MESSAGE" window - just ignore
it.
Then in the formula area put your cursor on the 1st IF statement and
then, double click on the Fx icon - next to the formula box.
You can have up to seven (7) If statements.
If you need more than seven you might have to use a "LOOKUP" Function.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=500968