| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
currency rates
Hi, Is there any way i can set the currencyrate In my worksheet cell "I"stands for P/S (P for Purchase,S for Sale) cell "J" for FCY If i am giving in cell "I" P and cell "K" USD, I wanted to get the currency Purchase rate in cell "K" .384 and the cell should accept the allowed .002 up and down. I mean i can change to .386 or .382. I hope i can create a table like the below in another sheet and brought to the above cells. but I dont know how to get it. (P for Purchase,S for sale) FCY PURCHASE SALE TOLERANCE USD .384 .386 .002 GBP .700 .710 .005 EUR .470 .480 .005 AED .1045 .105 .002 Tolerance stands for the rate can be change that much above or below,not fixed. But couldn't go beyond the tolerance limits. Please have a look on this matter. with regards nowfal. -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=399818 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
currency rates
hi, Nobody there to assist in this matter. -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=399818 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
currency rates
Hard to tell what you have and what you are trying to do.
If you have the table, then in another cell, if you enter USD into K, you can return something from the table with Vlookup. -- Regards, Tom Ogilvy "nowfal" wrote in message ... hi, Nobody there to assist in this matter. -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=399818 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
currency rates
HI Tom, I got it from the other forum, actually its my mistake of explaining what i wanted, b coz of time limit i couldn't explain the problem. Any how thanks for the response. by nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=399818 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
currency rates
Looked like the recommendation over there was vlookup.
-- Regards, Tom Ogilvy "nowfal" wrote in message ... HI Tom, I got it from the other forum, actually its my mistake of explaining what i wanted, b coz of time limit i couldn't explain the problem. Any how thanks for the response. by nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=399818 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| How do I import daily currency rates? | Excel Discussion (Misc queries) | |||
| import currency rates into Excel? | Excel Worksheet Functions | |||
| Conversion from currency value to currency text format | Excel Programming | |||
| Web Query for Currency Rates | Excel Programming | |||
![nowfal[_50_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
