Excel 2003 Formula if statements 1

[kcoleman26]

I am trying to write a formula to calculate tax based on weather or not someone is tax exempt or not.

If Room Rate = "$0.00" then "$0.00" else
It Tax Exempt(cell f5) = "Yes"
then (cell f9) else
if Tax Exempt(cell f5) = "No"
then f9*f10

I am not familar with VB but do have some experience in Crystal so I don't know if this formula could be done in excel. If may just need to be written differently.

Any Help Would be appreciated.

Thanks,
KC

 

[SkipVought]

Hi,

This is Excel, not VB...
[tt]
If Room Rate = "$0.00" then "$0.00" else
It Tax Exempt(cell f5) = "Yes"
then (cell f9) else
if Tax Exempt(cell f5) = "No"
then f9*f10

=if(Room_Rate=0,0,if(F5="Yes",F9,F9*F10))
[/tt]
assuming that you have a cell that has a RangeName of Room_Rate.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}