| 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if condition on currency formated cells
I have uploaded an example to http://www.nofavor.com/spreadsheet/narnimar.xls
-- http://HelpExcel.com "Narnimar" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if condition on currency formated cells
Dear Galimi, Your answer is perfect for only one combination of currency.
Sorry but I realize that did not questioned for the way I needed the answer. In fact in this example I am looking for the local currency value for a item purhase when I got different price quotations in different currencies. The data entered in C column are currency codes and the values in D column are the exchenge prices. 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) IF a price entered in E1 formated in $ currency then B1=E1*D2 which means depending on the cell format (example is in $) look at column C and find the exchange price from the column D and multply into the corresponding exchange rate 3.680 and return answer 9.20 The answer in B1 should change to if change the format to of E1 from $ to ぎ (means B1=E1*D2). Thank you and Sorry again. "galimi" wrote: Sorry, wrong location: http://www.nofavor.com/spreadsheets/narnimar.xls -- http://HelpExcel.com "Narnimar" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if condition on currency formated cells
Narnimar,
Please call me via http://www.ExcelHelp.us. It is a free call. I don't understand what I've missed. -- http://HelpExcel.com "Narnimar" wrote: Dear Galimi, Your answer is perfect for only one combination of currency. Sorry but I realize that did not questioned for the way I needed the answer. In fact in this example I am looking for the local currency value for a item purhase when I got different price quotations in different currencies. The data entered in C column are currency codes and the values in D column are the exchenge prices. 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) IF a price entered in E1 formated in $ currency then B1=E1*D2 which means depending on the cell format (example is in $) look at column C and find the exchange price from the column D and multply into the corresponding exchange rate 3.680 and return answer 9.20 The answer in B1 should change to if change the format to of E1 from $ to ぎ (means B1=E1*D2). Thank you and Sorry again. "galimi" wrote: Sorry, wrong location: http://www.nofavor.com/spreadsheets/narnimar.xls -- http://HelpExcel.com "Narnimar" wrote: 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? |
| Reply |
| 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) | |||
Linear Mode
