This is a GV report linked to Excel. With an XDView link it automatically updates Excel with the formula stored in Excel.

When I divide column E by column F I want the variance to show as a percentage. In the case where column F is 0 the formula works, but if E is 0 then I have an error and if both columns are 0 then it shows 100% where as it should show 0.
_________________________
Miriam Wiebil
ChoiceTech Accounting Solutions