Multiple "if" formulas
 

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

Multiple "if" formulas
 

In A1:

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


T_Sr wrote:

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

Multiple "if" formulas
 

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

Vaya con Dios,
Chuck, CABGx3



"T_Sr" <u17260@uwe wrote in message news:59d463117080b@uwe...
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

Multiple "if" formulas
 

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
--
paul
remove nospam for email addy!



"T_Sr" wrote:

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