This may be real simple, but...

[Cerberus]

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.

 

[Otto Moehrbach]

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

 

[Tom Hutchins]

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

Hope this helps,

Hutch

 

[FSt1]

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

 

[Dana DeLouis]

Here, B3+B4 is calculated once:

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Scott Sornberger]

,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")