Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
,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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Real Protection | Excel Discussion (Misc queries) | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |