ExcelBanter - I'm getting the #DIV/0! error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I'm getting the #DIV/0! error (https://www.excelbanter.com/excel-discussion-misc-queries/248573-im-getting-div-0-error.html)

Reverand Mooney

I'm getting the #DIV/0! error

When I'm calculating for a % I entered the IF formula =IF(B10=0,"",B10/C10)
and it worked ok when B10 was 0 but how would you modify this formula if
either B10 or C10 were 0? The result can display 0 for my purposes.

Thanks.

T. Valko

I'm getting the #DIV/0! error

Try it like this...

=IF(OR(B10=0,C10=0),0,B10/C10)

--
Biff
Microsoft Excel MVP

"Reverand Mooney" wrote in
message ...
When I'm calculating for a % I entered the IF formula
=IF(B10=0,"",B10/C10)
and it worked ok when B10 was 0 but how would you modify this formula if
either B10 or C10 were 0? The result can display 0 for my purposes.

Thanks.

Jacob Skaria

I'm getting the #DIV/0! error

Try
=IF(B10=0,"",IF(C10=0,0,B10/C10))

If this post helps click Yes
---------------
Jacob Skaria

"Reverand Mooney" wrote:

When I'm calculating for a % I entered the IF formula =IF(B10=0,"",B10/C10)
and it worked ok when B10 was 0 but how would you modify this formula if
either B10 or C10 were 0? The result can display 0 for my purposes.

Thanks.

All times are GMT +1. The time now is 05:13 AM.