I am using financial reporter (version 1.15.50.945) and am trying to add a simple column showing percentage variance to budget. Basically the formual is:
(Actual - budget)/Budget x 100.

The problem is if I have no budget i receive a Error! in the formula cell. Is there a way to return a blank cell or even a zero if a divide by zero error is received?

Thanks,

ken

Hi Ken,

Use the following formula:

=if(Budget=0,0,(Actual-Budget)/Budget x 100)

For example,

Assume the cell reference for Budget=B1 and Actual=A1 then,

=if(B1==0,0,(A1-B1)/B1*100)

For an example of this type of formula, see GL!BudgetPercent.sam in sample data.