View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.