| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Div/0
I have a formula in a cell that sums up some cells and then divides by
another cell. Staff will be entering data on each row, so I copied the formula down the entire column. So now in each cell it shows #DIV/0!...this is showing because none of the cells in the row have been populated yet. Is there a way to hide the formula in the cell so that the users don't see #DIV/0! when the row has not been used yet? -- Deb G |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Div/0
Instead of something like
=A1/B1 use =IF(B1=0,"",A1/B1) -- Gary''s Student gsnu200703 "Deb G" wrote: I have a formula in a cell that sums up some cells and then divides by another cell. Staff will be entering data on each row, so I copied the formula down the entire column. So now in each cell it shows #DIV/0!...this is showing because none of the cells in the row have been populated yet. Is there a way to hide the formula in the cell so that the users don't see #DIV/0! when the row has not been used yet? -- Deb G |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Div/0
Thank you Gary, I will give that a try!
-- Deb Geambazi "Gary''s Student" wrote: Instead of something like =A1/B1 use =IF(B1=0,"",A1/B1) -- Gary''s Student gsnu200703 "Deb G" wrote: I have a formula in a cell that sums up some cells and then divides by another cell. Staff will be entering data on each row, so I copied the formula down the entire column. So now in each cell it shows #DIV/0!...this is showing because none of the cells in the row have been populated yet. Is there a way to hide the formula in the cell so that the users don't see #DIV/0! when the row has not been used yet? -- Deb G |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with #DIV/0! error please please help me | Excel Discussion (Misc queries) | |||
| Need help with dividing and using ISERROR for Div/0! | Excel Worksheet Functions | |||
| Chart - date with errors #DIV/0! | Charts and Charting in Excel | |||
| How to hide #DIV/0! in cells waiting for input? | Excel Discussion (Misc queries) | |||
| replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
Hybrid Mode
