Text based on Values being Greater or Less than Zero

[KJM]

Hi everyone,

Apologies if this is very basic, I'm a real beginner.

I have a Text & Image box in my sheet to show the value from the expression: Sum([Actual £])-Sum([Revised Bud]) (this is just Sales vs Budget in £, not %).

I want to create an expression to return "Overbudget" if its a postive value or "Underbudget" if its negative.  I tried:

If((Sum([Revised Bud])-Sum([Actual £]))>0,"Overbudget","Underbudget")

But it tells me there's an error in the expression.  Perhaps it can't return strings?

Thanks in advance for any help/suggestions.

K.

[Digvijay_Singh]

Try with single quote instead of double quote - 

If((Sum([Revised Bud])-Sum([Actual £]))>0,'Overbudget','Underbudget')