Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need help setting up a sheet with travel expenses incurred in different
countries. These expenses will be converted into Swiss Francs (CHF) and US Dollars (USD). So it is that Column G displays USD converted values and column H, Swiss Franc, or CHF, converted values. Individual amounts are entered EITHER in column K (for Euro values),OR L (for pound - GBP values), OR in a column M for "floating" currencies, which can vary depending on what country was visited.. Columns I and J repeat the Swiss franc and dollar values respectively. Currently H2:H7 contain currency rates for the following: GBP =1CHF; 1 $= SEK; 1 $= GBP; 1 $ = CHF; 1 $ = ‚¬; 1CHF=‚¬; which are used as absolute reference cell addresses as the placeholders for conversion rates that are updated periodically for inclusion in formulas that will be in G 10 and H10 going down with every new expense entered. The conversion itself is simple, my question is how do I write a formula in G and H 10 that will check if there is a value in column K, and if so, convert it by the corresponding conversion value (single cell) in H2:H7, otherwise, check if there is a value in L and do the same, by a different cell address in H2:H7 otherwise run the formula on whatever value is in M (the "floating" currency), converted by now a third value in the H2:H7) range. I imagine a variation of an IF statement. The primary objective is to have a secretary input ONLY the updated currency rates in H2:H7 and the varying amounts in K10, OR 10, OR M10 down and have these values automatically converted by the formula in G and H to be added up at the end of all entries. -- Rene - Do appreciate your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|