IFNUMBER formula, help!

Bri Boyer

Good morning all,

 

I am trying to create a formula that essentially does a planned budget value - actual budget value to get the "budget variance" but only if there is a number in the actual budget field. Any suggestions? Right now it is only:



=[Budget Planned]26 - [Budget Actual]26

 

But when we have no actual numbers in there, it is making our budget variance quite large.

Mike Wilday

Try surrounding your formula with an IF statement.

=IF(Isblank([Budget Actual]26), "", [Budget Planned]26 - [Budget Actual]26)

That should give you a blank cell if there is no data in Budget Actual, but give you your formula if there is actual amounts listed. 

You would paste that formula into row 26 and use the bottom-right corner to drag it up and down throughout your sheet. 

Hope that helps!