Help with IF function

[rach572]

Hi there, I am currently completing a spreadsheet for an assignment and am completing a budget. The question ask in column H, create formulae using an appropriate function or functions to compare column G with B9 and automatically display the words ‘Over budget’ whenever there is a greater than +5% difference. I know the basics of IF functions but are stumped when it says whenever there is a more than 5% difference. How do I incorporate that into the function?

Thanks in advance,


Rachel

[MarvinP]

Hi Rachel and welcome to the forum,

I think you will need an Absolute Value in your test of the If function, because the value could be up or down. An example might be:

Start value = 100 and ending value = 115. Is the change greater than 5% difference? How would you do this??? Is the function here:

(ABS(100-115)/100) > .05 ?

I hope this helps.. But I don't want to give you a full answer without you thinking about it yourself.