I need to use appropriate function or functions to compare column G to B10 and return “Over budget” message whenever the results are +5% and leave blank when conditions are not met.
So far I’ve come up with
=IF(G23>B10+5%,”Over Budget”,””), but all of the columns display over budget message. While it could be true (I”m not very good at maths) its possible that it’s not.
What am I doin’g wrong with my formulae?