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