Problem with IF function

  • Thread starter Thread starter KeyAdministration
  • Start date Start date
K

KeyAdministration

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
 
Never mind... this isn't working at all for me!

Thanks
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support
 
Hi,
I assume that Chicago_Sales_Location_Yr1 is a named range?

I think you need quotes around the yes

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

Regards - Dave
 
Thank you Dave! I will have to try that... Thank you!
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support
 
It works!!!! thank you thank you thank you
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support
 
Back
Top