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
A sample spreadsheet would
A sample spreadsheet would help.