Forum Discussion
Excel formula
Hello,
I have been using excel to keep track of my spendings and savings for a few years and keep changing things or adding things to make it easier and better to use. My latest add-on is a bronze, silver and gold on how much I have saved per month (bronze-£600, silver-£700, gold-£850)
now I have the formula set up for these in separate chart so it’ll say goal achieves in each if I hit that amount. But I’m now wanting a main chart that shows which I had hit, so January bronze, February Silver and so on. My problem being is I cannot figure out the formula.
I need a formula that will give multiple answers, I tried using if but that only gives me two outcomes (true or false) but I need four outcomes (not achieved, bronze, silver and gold)
are you able to help?
- OliverScheurichGold Contributor
=IF(A2>=850,"gold",IF(A2>=700,"silver",IF(A2>=600,"bronze",IF(A2<600,"not achieved"))))
You can try a nested IF formula.