Combining IF with subtraction??

[Noel Lackey]

Hi,
any idea how I could write a formula for this? I know how to do the IF statement but how do I combine the two?
--------------------------------------------------------------
A calculation to show the difference between the budget and the actual figures and an if statement to show if the event was over or under budget.
Thanks,
Noel

 

[eibi]

Welcome to the forums!

Something like this?

=IF(Budget-Actual>=0,Budget-Actual&" Under", Actual-Budget&" OVER")

=IF(A2-B2>=0,A2-B2&" Under", B2-A2&" OVER")

See attached.

 

[Sudhir Prabhu]

Try this :
=IF(budget-actual>=0, "Surplus "& budget-actual, "Deficit "&budget-actual)

replace "Budget" and "actual" with the cells containing the appropriate values.

reg
Sudhir

 

[David Evans]

Here's a couple of ways of doing it - conditional formatting is my preference, but there's another method in there also ....

 

[Noel Lackey]

Thank you all for your quick replies, this is the solution supplied with the exercises, I just cannot figure out how to include include budget-actual into the formula? In the solution it shows at the end after the "by", the formula below is how it appears in the solution.
Regards,
Noel
=IF(C7>B7,"Over Budget","Under Budget")

byl=C7-B7