EXCEL custom currency converter, what formulas will help me????

i need to know how to get this result: i have my own three cells, euro, pounds and ringit. need to input numbers at anytime one of the three currency that will convert itselfs into the other two currencies. how do i do it? please helpppppp

Public Comments

1. To do this with just formulas you will need to use three columns and four rows. The description below assumes the use of the range from B2 through D5. You can move the setup elsewhere after it is coded and tested if you want or need to. Row 2 contains column names Euros, Pounds and Ringits Row 3 must contain a representation of the current exchange rates. The three values must express equivalent values in Euros, Pounds, and Ringits. For example, if Euros was set at 1, the Pounds would be the number of pounds you would get in exchange for 1 Euro and Ringits would be the number of Ringits you would get for 1 Euro. Row four should contain only one value at any time. It must be the value you want to convert from placed in the column for the currency you want to convert from. There will be an example shortly. Row 5 must contain the following formulas in the columns indicated (starting with the equal sign): Column B =IF(B4>0,B4,IF(C4>0,B3*C4/C3,B3*D4/D3)) Column C =IF(C4>0,C4,IF(D4>0,C3*D4/D3,C3*B4/B3)) Column D =IF(D4>0,D4,IF(B4>0,D3*B4/B3,D3*C4/C3)) If the exchange rate were such that you would get 1.5 Pounds or 2 Ringits for 1 Euro and you want to convert 61.55 Euros the result would look like _____Euros_____Pounds______Ringit _____ 1.00 _____ 1.50 ______ 2.00 _____61.55 _____61.55 _____92.33 ______ 123.10 If instead you wanted to convert 61.55 Pounds, you would delete the contents of cell B4 and enter 61.66 into cell C4 to get the following _____Euros_____Pounds______Ringit _____ 1.00 _____ 1.50 ______ 2.00 _______________61.55 _____41.03 _____61.55 ______ 98.07 The underscores are just to maintain spacing and should be though of a spaces. This is about the simplest formula only approach and avoids the big problem of new entry destroying formulas you will need again and again. I strongly recommend that once you get the formulas right, you protect them. Note that you have to maintain the exchange rate information if you want to get accurate conversions. There is a somewhat simpler solution available using VBA macros that doesn’t require the extra row for entering the value to be converted. If you are interested in that instead of formulas, please contact me via Answers email and I will send you the macro needed.