| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return cell reference from any column | Excel Worksheet Functions | |||
| Formula to return the name of a cell | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Hybrid Mode
