Good morning Excel Guru's
Trust you are all well. I need your assistance in formulating a formulae to avoid #DIV/O! error when I compute the variance %age if the divisor is zero(0). I would love to have for INCOME a +100% as the variance % if the budget amount is zero. and for EXPENSES a neg/ -100% if the budget is zero.
Find attached worksheet for your perusal (Hope to have it coz Ive been struggling to attach the file). Many thanks!
Bookmarks