| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if condition on currency formated cells
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'm looking to add cells (that are formated in %) in them. | Excel Worksheet Functions | |||
| Sumif only numbers formated as currency | Excel Worksheet Functions | |||
| Don't Want to Print Formated Blanked Out Cells | Excel Discussion (Misc queries) | |||
| CONCATENATE Cells Formated as fractions | Excel Worksheet Functions | |||
| Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Threaded Mode
