Display 0% rather than -

[seshultz]

Well since I got such great response so quickly, I'll try you for another question!

I am using the formula =IF(ISERROR(P7/Q7),"-",P7/Q7) to display a "-" rather than an error when the data isn't yet entered for calculcation.

However, if data is entered for calculation and denominator is 0, I want it to display a 0 (or NA or something else) rather than a -, so it will be obvious data was entered.

Is this possible?

Thanks!

 

[T. Valko]

Well since I got such great response so quickly, I'll try you for another question!

I am using the formula =IF(ISERROR(P7/Q7),"-",P7/Q7) to display a "-" rather than an error when the data isn't yet entered for calculcation.

However, if data is entered for calculation and denominator is 0, I want it to display a 0 (or NA or something else) rather than a -, so it will be obvious data was entered.

Is this possible?

Thanks!

Maybe this...

=IF(Q7=0,0,P7/Q7)

 

[seshultz]

Thanks T. Valko. But that seems to put a 0 in every calculated cell, as well as everyone which hasn't been calculated yet.

I think I am getting 2 different errors - both because it doen't like 0 or no data entered in the denominator. I want to display something different if there is noting entered in the denominator cell (- or NA because the only reason I am getting the error is because data has not yet been entered) and I want a 0 to display if the data entered was a 0.

THanks very much,
Sarah

 

[seshultz]

I should have mentioned I'm using 2003....sorry!

 

[T. Valko]

Thanks T. Valko. But that seems to put a 0 in every calculated cell, as well as everyone which hasn't been calculated yet.

I think I am getting 2 different errors - both because it doen't like 0 or no data entered in the denominator. I want to display something different if there is noting entered in the denominator cell (- or NA because the only reason I am getting the error is because data has not yet been entered) and I want a 0 to display if the data entered was a 0.

THanks very much,
Sarah

Ok, try this...

=IF(Q7="","N/A",IF(Q7=0,0,P7/Q7))

 

[seshultz]

Thank you so much!!!

 

[T. Valko]

Thank you so much!!!

You're welcome. Thanks for the feedback!