Divide by Zero error

afineline

Hello,

 

I have the following formula to calculate % Over/Under Budget:

=[$ (Over)/Under Budget]8 / [FOOD BUDGET July 2018]8

I would like this to work even when there is a 0 in the Budget number and even when "over/under" is 0.

 

Thank you for your help.

 

Todd

J. Craig Williams

Either account for 0

=IF([FOOD BUDGET July 2018]@row = 0, 0, [$ (Over)/Under Budget]@row/ [FOOD BUDGET July 2018]@row)

or catch the error

=IFERROR([$ (Over)/Under Budget]@row/ [FOOD BUDGET July 2018]@row), 0)

Both of these return 0 if there is a divide by 0.

Craig