If Statement - Please help

[houmoore4]

I am currently working on a rate exchange table. I know that I need a nesting an if statement with a vlookup, but am confused.

In cell D5 (on page 1-currency calculator), I have a list of countries to pick from. In cell e5, I would like to be able to type in a dollar amount, in column e6 I would like to calculate the current rate of exchange for the amount in e5.

Currency Value
Argentine Peso $5.00
U.S. $ = column 2, on curance rate page * $5.00

Page 1: Currency Calculator
Page 2: Currance Rate
column 1: country name
column 2: in US $$
column 3: Per US $$

So if I had $500 in US money, how much would I get if I went to Italy at the current rate of exchange.

I've been working on this for hours...Can anyone help.

Thanks

Houmoore4

[tkaplan]

i would create a lookup table - on page 1 name a range "CurrencyCalculator" and have the list of countries and what their currency rate exchange is.
page 2:

a1: enter in a dollar amount
b1: select country from the currency calculator list
c1: type in : =VLOOKUP(B1,CurrencyCalculator,2,FALSE)*A2


for example
Page 1
column a column b

1 us 1.00
2 canada 1.75
3 europe 0.84

select all the cells with the data in them and go to insert-->name-->define and in the name type in "CurrencyCalculator"

page 2
column a column b column c
1 5.00 europe =VLOOKUP(B1,CurrencyCalculator,2,FALSE)*A2 which will give you the value 4.2

I am currently working on a rate exchange table. I know that I need a nesting an if statement with a vlookup, but am confused.

In cell D5 (on page 1-currency calculator), I have a list of countries to pick from. In cell e5, I would like to be able to type in a dollar amount, in column e6 I would like to calculate the current rate of exchange for the amount in e5.

Currency Value
Argentine Peso $5.00
U.S. $ = column 2, on curance rate page * $5.00

Page 1: Currency Calculator
Page 2: Currance Rate
column 1: country name
column 2: in US $$
column 3: Per US $$

So if I had $500 in US money, how much would I get if I went to Italy at the current rate of exchange.

I've been working on this for hours...Can anyone help.

Thanks

Houmoore4

[swatsp0p]

Hi, Tkaplan. Welcome to the Forum. I have a quick question on your solution.

c1: type in : =VLOOKUP(B1,CurrencyCalculator,2,FALSE)*A2

Do you mean "....*A1" not A2?

Cheers!

Bruce