ExcelBanter - if/or statement

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if/or statement (https://www.excelbanter.com/excel-discussion-misc-queries/174130-if-statement.html)

dchristo

if/or statement

ex. if d3 = cell A1 OR cell A2 OR cell B5 OR cell B6,"NOTHING FURTHER
NEEDED","CONTACT SUPERVISOR")

how do I make this work

ShaneDevenshire

if/or statement

Hi,

Try
=IF(OR(D3=A1,D3=A2,D3=B5,D3=B6),"NOTHING FURTHER NEEDED","CONTACT SUPERVISOR")

--
Cheers,
Shane Devenshire

"dchristo" wrote:

ex. if d3 = cell A1 OR cell A2 OR cell B5 OR cell B6,"NOTHING FURTHER
NEEDED","CONTACT SUPERVISOR")

how do I make this work

dchristo

if/or statement

perfect, thank you very much

"ShaneDevenshire" wrote:

Hi,

Try
=IF(OR(D3=A1,D3=A2,D3=B5,D3=B6),"NOTHING FURTHER NEEDED","CONTACT SUPERVISOR")

--
Cheers,
Shane Devenshire

"dchristo" wrote:

ex. if d3 = cell A1 OR cell A2 OR cell B5 OR cell B6,"NOTHING FURTHER
NEEDED","CONTACT SUPERVISOR")

how do I make this work

All times are GMT +1. The time now is 09:38 PM.