ExcelBanter - If Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If Statement (https://www.excelbanter.com/excel-worksheet-functions/158753-if-statement.html)

scotty

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

Bernard Liengme

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

scotty

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

All times are GMT +1. The time now is 08:20 AM.