Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax question
Hello,
I am trying to write a form, with a yes or no field in it. My formula currently reads =IF(G18=Yes,3,0) It gives me an error and put #NAME? on the field it controls. When I looked at the error the error read =IF(Yes=Yes,3,0) it wasn't using the cell reference but the content. What am I missing? I have IF statements all over this form, and the only difference I see is that this one is alpha instead of numeric. Please advise THANKS Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA syntax question | Excel Discussion (Misc queries) | |||
question about syntax in a simple macro... | Excel Discussion (Misc queries) | |||
syntax question | Excel Worksheet Functions | |||
BringToFront syntax question | Charts and Charting in Excel | |||
Data Validation Syntax Question | Excel Discussion (Misc queries) |