#Div/0 is popping up all over my spreadsheets. I know that this is because I'm trying to divide by 0, but is there any way to make excel return the value 0 instead of #Div/0?
All of the solutions I've found so far for this depend upon a formula string such as the following: =IF(denominator=0,"",numerator/denominator). This isn't working for me because (I believe) my denominator is being calculated inside of the formula, so I'm getting something akin to a circular reference error message. Is there any other way around this error code?
All of the solutions I've found so far for this depend upon a formula string such as the following: =IF(denominator=0,"",numerator/denominator). This isn't working for me because (I believe) my denominator is being calculated inside of the formula, so I'm getting something akin to a circular reference error message. Is there any other way around this error code?