Formula that displays words - help please

[pammy66]

I need help with a formula that will display the words over buget if the the difference between 2 cells is +5%

[vlady]

I think you have to explain more on what you want to attain, a sample of the file your working on and expected outcome.

but here goes nothing.

=if((firstcell-secondcell)=.5,"Display this word","")
the bold part says blank if it is not equal to .5 or 5%

[pammy66]

if I had 45% in one cell and 40.55% in another then What I need to know is if 45% is more than 5% greater than 40.55% then display the words "over budget" if not leave blank

Hoping this makes some sense

[vlady]

=IF((A1-A2)>=5%,"Overbudget","")

A1 is 45%
A2 is 40.55%

i used >= you can edit that..

[pammy66]

Thanks vlady that is great, thanks for the help

[vlady]

thanks for the rep.