Formulae help

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?

By: Susan

Leave a Reply

Your email address will not be published. Required fields are marked *