Something like:

=if(a1<4,$ formula,% formula)

Does that help?

--
Regards,
Fred


"Rahim Jaffer" <Rahim wrote in message
...
I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in Percentage
or in Dollars.

Rahim Jaffer