View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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.