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

Problem with IF function
 

Never mind... this isn't working at all for me!

Thanks
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support


"KeyAdministration" wrote:

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

Problem with IF function
 

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

Problem with IF function
 

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

Key Administration
Comprehensive Business Support


"Dave" wrote:

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

Problem with IF function
 

It works!!!! thank you thank you thank you
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support


"Dave" wrote:

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

Problem with IF function
 

You are very welcome.
Dave