This may be real simple, but...
 

I am trying to do an IF equation but I have two values that I want to be
true, how would I go about this? Basically I want 2 or 3 to equal €œgo€� and
everything else equal €œno go€�. I have tried to use something like this

IF((B3+B4)=2<3,€�no go€�,€�go€�

but that did not work.
Thank you all for your help.

This may be real simple, but...
 

Not sure what you want but I think you want "no go" if B3+B4 equals 2 or 3,
and "go" if not.
If that's what you want:
=IF(OR(B3+B4=2,B3+B4=3),"go","no go")

HTH Otto

"Cerberus" wrote in message
...
I am trying to do an IF equation but I have two values that I want to be
true, how would I go about this? Basically I want 2 or 3 to equal "go"
and
everything else equal "no go". I have tried to use something like this

IF((B3+B4)=2<3,"no go","go"

but that did not work.
Thank you all for your help.

This may be real simple, but...
 

=IF(OR(B3+B4=2,B3+B4=3),"go","no go")

Hope this helps,

Hutch

"Cerberus" wrote:

I am trying to do an IF equation but I have two values that I want to be
true, how would I go about this? Basically I want 2 or 3 to equal €œgo€� and
everything else equal €œno go€�. I have tried to use something like this

IF((B3+B4)=2<3,€�no go€�,€�go€�

but that did not work.
Thank you all for your help.

This may be real simple, but...
 

hi
your request is a bit confusing but i think this may help...
=IF(OR(B3+B4=2,B3+B4=3),"no go", "go")

post back if i'm off from your meaning.

Regards
FSt1

"Cerberus" wrote:

I am trying to do an IF equation but I have two values that I want to be
true, how would I go about this? Basically I want 2 or 3 to equal €œgo€� and
everything else equal €œno go€�. I have tried to use something like this

IF((B3+B4)=2<3,€�no go€�,€�go€�

but that did not work.
Thank you all for your help.

This may be real simple, but...
 

Here, B3+B4 is calculated once:

=IF(OR(B3+B4={2,3}),"Go", "No Go")

--
HTH
Dana DeLouis

"Cerberus" wrote in message
...
I am trying to do an IF equation but I have two values that I want to be
true, how would I go about this? Basically I want 2 or 3 to equal €œgo€�
and
everything else equal €œno go€�. I have tried to use something like this

IF((B3+B4)=2<3,€�no go€�,€�go€�

but that did not work.
Thank you all for your help.

This may be real simple, but...
 

=IF(OR(B3+B4=2,(B3+B4=3)),"go","no go")


Gord Dibben MS Excel MVP

On Tue, 18 Mar 2008 10:05:12 -0700, Cerberus
wrote:

I am trying to do an IF equation but I have two values that I want to be
true, how would I go about this? Basically I want 2 or 3 to equal “go” and
everything else equal “no go”. I have tried to use something like this

IF((B3+B4)=2<3,”no go”,”go”

but that did not work.
Thank you all for your help.

This may be real simple, but...
 

,How about this.

if(and((B3+b4)2,(B3+B4)<3)),"no go","go)

in english.
if sum is greater than 2 and sum is less than 3 then true ("no go") else
false ("go")

"Dana DeLouis" wrote:

Here, B3+B4 is calculated once:

=IF(OR(B3+B4={2,3}),"Go", "No Go")

--
HTH
Dana DeLouis

"Cerberus" wrote in message
...
I am trying to do an IF equation but I have two values that I want to be
true, how would I go about this? Basically I want 2 or 3 to equal €œgo€�
and
everything else equal €œno go€�. I have tried to use something like this

IF((B3+B4)=2<3,€�no go€�,€�go€�

but that did not work.
Thank you all for your help.