IF Formula

[Barny]

Hi, I'm not that good on excel so would appreciate some help.

Basically I need the formula to

A. Budget = £100
B. Spend = x
C. Left = X
D. Over Budget = amount which is over the over the budget i.e A - B = C, if B>A then show the difference - does that make sense?

Any help gratefully received

 

[Bob Greenblatt]

Hi, I'm not that good on excel so would appreciate some help.

Basically I need the formula to

A. Budget = £100
B. Spend = x
C. Left = X
D. Over Budget = amount which is over the over the budget i.e A - B = C, if
B>A then show the difference - does that make sense?

Any help gratefully received

In column D:
=if(b1>a1,b1-a1,"")