Forum Discussion
How to make a cell dependant on another, and perform different calcs based on the orginal cell?
Hi, My excel skills are average at best and I am trying to track my trades better so I have tried to create a sort of ledger; however I have hit a brick wall. I am trying to make the spreadsheet t...
Hi CobyCurtis
You can adjust the formula to
=IFS(F12="GBP",Q12,F12="USD",Q12*0.8,F12="EUR",Q12*0.88)
With this, you will get the intended value.
However, I believe you can set up your data in a better way, so you won't hardcode the numbers in your formula, for example, have a table for the values of each GBP, USD and EUR.
You can then use INDEX and MATCH or VLOOK (XLOOK is also useful)
=INDEX($A$1:$B$3,MATCH($F$12,$A$1:$A$3,0),2)*$Q$12
Cheers,