IF Formula

B

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
 
B

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
Click to expand...
In column D:
=if(b1>a1,b1-a1,"")
 
Top