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