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