ExcelBanter - How Do You Hide a #DIVO! Return in a cell

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

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

- - How Do You Hide a #DIVO! Return in a cell (https://www.excelbanter.com/excel-worksheet-functions/56336-how-do-you-hide-divo-return-cell.html)

rpalmer4

How Do You Hide a #DIVO! Return in a cell

Ok, what is the formula to return a blank cell vs. a #DIVO! ? My formula
currently is =1-(C15/G15) however when C15 is 0 my return is #DIVO! I would
like for the cell to remain blank if the c15 cell is 0.

Dave Peterson

How Do You Hide a #DIVO! Return in a cell

One way:

=if(g15=0,"",1-(C15/G15))

I think the problem is with G15--not C15.

rpalmer4 wrote:

Ok, what is the formula to return a blank cell vs. a #DIVO! ? My formula
currently is =1-(C15/G15) however when C15 is 0 my return is #DIVO! I would
like for the cell to remain blank if the c15 cell is 0.

--

Dave Peterson

Ron Coderre

How Do You Hide a #DIVO! Return in a cell

Try this:
=IF(N(G15)=0,"",1-(C15/G15))

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron

"rpalmer4" wrote:

Ok, what is the formula to return a blank cell vs. a #DIVO! ? My formula
currently is =1-(C15/G15) however when C15 is 0 my return is #DIVO! I would
like for the cell to remain blank if the c15 cell is 0.

All times are GMT +1. The time now is 06:18 AM.