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.
