| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement
I have the monthly name September in one cell (A1) and October in another
cell (B1). How can I create an "if" statement that says if cell A1 or B1 = September then return figure in Cell C1 else zero? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
=IF(OR(A1="September",B1="September"),C1,0)
or ((A1="September")+(B1="September"))*C1 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Scotty" wrote in message ... I have the monthly name September in one cell (A1) and October in another cell (B1). How can I create an "if" statement that says if cell A1 or B1 = September then return figure in Cell C1 else zero? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
Thanks. I couldn't figure out the "or" part.
"Bernard Liengme" wrote: =IF(OR(A1="September",B1="September"),C1,0) or ((A1="September")+(B1="September"))*C1 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Scotty" wrote in message ... I have the monthly name September in one cell (A1) and October in another cell (B1). How can I create an "if" statement that says if cell A1 or B1 = September then return figure in Cell C1 else zero? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| IF statement or | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
