Multiple "if" formulas

[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

 

[Dave Peterson]

In A1:

=if(or(b1=1,c1=2,d1=3),10,"whatgoeshere")

 

[CLR]

=IF(OR(B1=1,C1=2,D1=3),10,"")

Vaya con Dios,
Chuck, CABGx3

 

[paul]

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