Multiple "if" formulas

  • Thread starter Thread starter T_Sr
  • Start date Start date
T

T_Sr

Hello I'm new here and this may have been answered already, however I've been
unable to find the answer.
I'm trying to have one cell (A1) give me a set number (10), if (B1=1) or
(C1=2) or (D1=3) for example. Any help on this topic would be greatly
appreciated. Let me know if there are any questions.

Thanks,
T_Sr
 
this formula will do exactly what you suggest,look at the or and
functions..in A1 type
=IF(OR(B1=1,C1=2,D1=3),10,"").So if any of tose conitions are true a1 will
show 10 if ALL are false it wil be blank
 
Back
Top