| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement syntax
What is the proper syntax for a non-nested, two-condition IF statement?
Example: IF(C16<1 & C151,-B15). This syntax appears to work when the two elements of the condition are simultaneously true. Unfortunately, -B15 is apparently always returned, even when the two conditions are not simultaneously true. What up? How do I get this right? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA syntax | Excel Discussion (Misc queries) | |||
| if statement syntax help | Excel Worksheet Functions | |||
| need help with syntax of if statement | Excel Worksheet Functions | |||
| when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
| when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
Threaded Mode
