Hello, I am very new to Excel and have a problem I'm trying to solve. I
think I've figured out how to use the nested IF function for normal
problems but this one adds an extra twist that I can't figure out.

I'm trying to create a commission formula that is based on
percentages.

Example: a salesman will receive a 5% commission for selling 98% or
more of the asking price of a car.

If I have the asking price in D2 and the actual selling price in C2.
How do I reference them in my formula? I tried different methods but I
kept getting an error message.

Thanks, Brette


--
brette73
------------------------------------------------------------------------
brette73's Profile: http://www.excelforum.com/member.php...o&userid=30761
View this thread: http://www.excelforum.com/showthread...hreadid=504264