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