ExcelBanter - Divide by Zero

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Divide by Zero (https://www.excelbanter.com/excel-worksheet-functions/23162-divide-zero.html)

rocky

Divide by Zero

Formula for the following
E20/E22*167
When E20 is empty or not use, howt to write the formula that will ignore E20
and continue wiyh the rest
E20(noy used) and E22 *167 is done.

º¼ÖÝÈË

if(isblank(E20),E22*167,E20/E22*167)

"rocky" Ð´ÈëÓÊ¼þ
...
Formula for the following
E20/E22*167
When E20 is empty or not use, howt to write the formula that will ignore
E20
and continue wiyh the rest
E20(noy used) and E22 *167 is done.

º¼ÖÝÈË

=IF(OR(E20=0,ISBLANK(E20)),E22*167,E20/E22*167)

Duke Carey

You're not going to get a divide by zero error from that formula if E20 is
blank, but you will if E22 is blank. Maybe what you want is:

=E20*167/(if(E22=0,1,E22)

"rocky" wrote:

Formula for the following
E20/E22*167
When E20 is empty or not use, howt to write the formula that will ignore E20
and continue wiyh the rest
E20(noy used) and E22 *167 is done.

All times are GMT +1. The time now is 07:56 AM.