View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default 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