| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple if condition formula required
One idea
In C1: =B1*HLOOKUP(A1,D1:G2,2,0) should yield the required result -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "Narnimar" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple if condition formula required
Thanks Max. I have similar problem. In this case the cells are formatted to
different currencies E1 is in USD currency formated as $2.5, F1 as ‚¬ 1.7, G1 as £1.9 and H1 is formated as AED9.0 Now, C2=USD and D2=3.6800 (General) C3=EUR and D3=4.7000 (General) C4=GBP and D4=5.7000 (General) C5=AED and D5=1.0000 (General) So, IF E1=$2.5 then B1=E1*D2 IF F1=‚¬1.7 then B1=F1*D3 IF G1=£1.9 then B1=G1*D4 IF H1=£9.0 then B1=H1*D5 I need the result in B1 with respective currency according to the if condition. I need one more result in B2 with general format IF E1=$2.5 then B2=E1*D2*N1 IF F1=‚¬1.7 then B2=F1*D3*N1 IF G1=£1.9 then B2=G1*D4*N1 IF H1=£9.0 then B2=H1*D5*N1 How can I try that? Thanks again. "Max" wrote: One idea In C1: =B1*HLOOKUP(A1,D1:G2,2,0) should yield the required result -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "Narnimar" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple if condition formula required
I'm out on your new query, sorry.
Maybe others would have ideas for you. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:362 Subscribers:64 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Scenario Condition Formula | Excel Worksheet Functions | |||
| Multiple Lookup as condition in sumproduct formula | Excel Worksheet Functions | |||
| What formula/fn would I use to count multiple condition records? | Excel Worksheet Functions | |||
| Multiple Condition Formula | Excel Worksheet Functions | |||
| Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Hybrid Mode
