Excel - Any Help On If Statements

B

BONJOVI2005

Dont no if this will help - but here's goes.

I am doing an assignment at uni, which involves building a model o
excel and then doing a report.

What I am having difficulty with is that you have to convert currenc
into dollars - which is the only problem I having. You had to import
database with all the data on which I have done and then import
conversion table from the msn website - which I have also done. What
dont understand is that the book which we are using has the assignmen
more or less in but isnt good on the idea I need. Its says you creat
an IF statement to convert the currency but I am having some troubl
with it.

Any Help would be appreciated.

Cheers in advance.

Marti
 
B

BONJOVI2005

Biff said:
Hi!

You need to provide more specific details.

Biff


Hi,

Thanks for getting back to me.

What it is, is that you import a database and a conversion rate into
excel - which I have done.
The assignment is about sales for each company by state - and some of
the states need to be converted from british columbia and canada. You
are meant to convert these currencies by using an IF statement. I sort
of understand the IF function by am not sure how to do this - what is
the logical test in thi formula. Would it be that if this cell contains
CA or BC then change.

Chers

p.s: British columbia and canada are shown on the spreadshet as BC and
CAN respectively.
Click to expand...
 
Top