IFNUMBER formula, help!
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.