View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Scott Sornberger Scott Sornberger is offline
external usenet poster
 
Posts: 12
Default 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.