software

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


This is a start:
=IF(AND(A1gt;=10000,A1lt;=20000),A1*15%,IF(AND(A1gt;2000 0,A1lt;=25000),A1*10%,quot;Your
Entryquot;))
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 lt;=25000, then A1*10%.
Select an IF Function and then select the AND function - when you close
the quot;ANDquot; function you will get an quot;ERROR MESSAGEquot; 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 quot;LOOKUPquot; Function.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=500968