| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I hide a calulation error in cells/table #div/0!
The calulation is to have data entered at a later date but with no data on
the cell to be divided the answer cell show #div/0! But I want this left blank, not showing the error. I can change one at a time but not all at once. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I hide a calulation error in cells/table #div/0!
If your formula is =A1/B1, you can avoid the divide by zero error when B1 is
empty by using =IF(B1="","",A1/B1). If you want the result to be blank if either A1 or B1 or both is missing, you could use =IF(OR(A1="",B1=""),"",A1/B1). -- David Biddulph "Dave" wrote in message ... The calulation is to have data entered at a later date but with no data on the cell to be divided the answer cell show #div/0! But I want this left blank, not showing the error. I can change one at a time but not all at once. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide the #N/A error | Excel Discussion (Misc queries) | |||
| Getpivot calulation | Excel Worksheet Functions | |||
| Hide #div/0 Error When Averaging | Excel Worksheet Functions | |||
| Pivot Table - hide blank cells | Excel Discussion (Misc queries) | |||
| Hide Pivot Table Divide by 0 error | Excel Worksheet Functions | |||
Linear Mode
