LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 168
Default Ex Rate

hello,
i am doing following formula in C1 but facing error !

Col_A Col_B Col_C
Amount Ex.Rate US$

SGD 100 10.00 USD 1,000 (=A1*B1) this type is okay
USD 100 00.00 USD 100 ( in USD case i just want bring same
amount in C1 100 as of A2) I copied C1~C100 formula

Hope you could understand it.
Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to calculate billable rate using base rate and percentage Felicia Pickett Excel Worksheet Functions 3 February 28th 10 12:26 PM
Calculating a daily rate when the rate could be fixed or variable cjgd1064 New Users to Excel 2 September 26th 08 12:06 AM
Prime rate/Liber rate into sheet automatically? Nixt Excel Discussion (Misc queries) 0 January 21st 06 09:49 PM
Real RATE of return using =RATE illusive, inflation adjusted inflo Pro - Land Excel Worksheet Functions 4 November 1st 05 03:06 AM
APR - Annual Percentage Rate to Actual Interest Rate Safu Excel Worksheet Functions 9 May 18th 05 05:03 AM


All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"