Thread: Multiple if condition formula required
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff Harald Staff is offline
external usenet poster
  
Posts: 292
Default Multiple if condition formula required
=B1*HLOOKUP(A1,D1:Z2,2,FALSE)

HTH. Best wishes Harald

"Narnimar" skrev i melding
...
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