If you're getting #Div/0! from =100%-I8, it's because I8 has the error
#Div/0!
You could test for the divisor in I8 being zero, and if so set your formula
result to zero.
--
David Biddulph


Elaine wrote:
I am getting #Div/0! with the following formula.. I want it to
display 0% in the cell.

=100%-I8

Thanks!