| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with syntax of if statement
I have a workbook in which on worksheet 1, cell A40 has the formula:
=average(B8:B38) Then, on worksheet 2, I would like the cell A1 to have: = worksheet 1'!B40 EXCEPT, if the result equals zero, then I would like the result to say "NODI=C". What syntax do I use to formulate this IF STATEMENT? In plain words, I want it to be: = worksheet 1!B40, enter the result, if the result is zero, then display "NODI=C" -- Melody |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The NOW() syntax | Excel Discussion (Misc queries) | |||
| VBA syntax | Excel Discussion (Misc queries) | |||
| If then syntax | 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
