| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem with IF function
You are very welcome.
Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAX / MIN function problem | Excel Discussion (Misc queries) | |||
| Problem With IF Function | New Users to Excel | |||
| Problem with IF function.... | Excel Worksheet Functions | |||
| Problem with the VALUE function | Excel Discussion (Misc queries) | |||
| FV Function Problem | Excel Worksheet Functions | |||
Linear Mode
