View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KeyAdministration KeyAdministration is offline
external usenet poster
 
Posts: 9
Default Problem with IF function

What is wrong with the following?

=IF(C3=yes,Chicago_Sales_Location_Yr1*0.05,"")

I'm getting $0 as an answer when it should be $55,000.

thanks
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support