Forum Discussion

Macauley81101's avatar
Macauley81101
Copper Contributor
Jan 18, 2023

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?

Resources