Setting up multiple conditions

[Jimper]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I need help setting up a conditional formula where there are multiple conditions: IF A OR B OR C is True (or Not True), then Value 1, otherwise Value 2.

I've tried a number of times -- for example: IF((E5'') OR(F5'')OR(G5''),'√',''), to mean if cell E5 or F5 or G5 is not empty, then '√', otherwise leave empty.

Hope someone can help. MTIA!

 

[John_McGhie_[MVP]]

You need an IF and an OR:

=IF(OR((E5<>""),(F5<>""),(G5<>"")),"√", " ")

Obviously, take great care with your relationships: ORs can be snaky little
varmints. That formula produces &#8730 unless all three are blank. And it
considers "0" to be a non-blank.

I hope this is what you want.

Hope this helps

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I need help setting up a conditional formula where there are multiple
conditions: IF A OR B OR C is True (or Not True), then Value 1, otherwise
Value 2.

I've tried a number of times -- for example: IF((E5'')
OR(F5'')OR(G5''),'√',''), to mean if cell E5 or F5 or G5 is not empty,
then '√', otherwise leave empty.

Hope someone can help. MTIA!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[Jimper]

John,

Hey, that's great! Just what I needed.

Many thanks!