Thread: Multiple if condition formula required
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Narnimar Narnimar is offline
external usenet poster
  
Posts: 132
Default Multiple if condition formula required
How to construct a formula if there are many if condition like this-
IF(A1=D1) then C1=B1*D2
IF(A1=E1) then C1=B1*E2
IF(A1=F1) then C1=B1*F2
IF(A1=G1) then C1=B1*G2

Reply With QuoteReply With Quote