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

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

=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

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