Using data validation and formulas

Basically I have a business spreadsheet that has several tabs along the bottom.
One of the sheets is an assumptions page which gives a rundown of all currency exchange rates and inflations prices for years to come.
I have based my spreadsheet on a 10% increase every year for all equipment items.

On the top of my spreadheet I have a cell using data validation which has the following:
whether escalation is required, the year we are carrying out the job and the currency we are quoting in.

What I want to do is, if the year 2014 is picked, I want my escalation colum to calculate the cost with a 20% increase.

If USD is selected I want the spreadheet costs to calculate the cost using the exchange rates stated in the assumptions page.

How would I do this, any ideas?

Many thanks in advance and I hope this makes sense!!

I currently have this formula for converting to USD:

=IF(J10="USD",+K23*BREAKDOWN!N15)

J10 - Currency (data validation list)
K23 - Total sell price
Breakdown N15 - currency exchange rate

If you need to know anything else, please let me know.

Not sure I fully understand

Not sure I fully understand but if you want to determine which formula to use, try this formula

I am not sure if J10 is a drop down, but it sounds like you can select either USD or 2014

If that is true then the formula would be
=IF(J10="USD",K23*Breakdown!N15,K23*.20)

Hope this helps

Marty

Vishesh's picture

A sample spreadsheet would

A sample spreadsheet would help.