| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
$DIV/0!
If I want to divide 2 cells to get an average and there is no # in cell yet
the cell where the fomula reads $DIV/0! I would like that cell to be blank. how do I write the formula. my formula reads =(J5/L5) my answer in that cell reads $DIV/0! since i do not have any data yet thanks -- Message posted via http://www.officekb.com |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
$DIV/0!
=if(l5=0,"",j5/l5)
or "Darts via OfficeKB.com" wrote: If I want to divide 2 cells to get an average and there is no # in cell yet the cell where the fomula reads $DIV/0! I would like that cell to be blank. how do I write the formula. my formula reads =(J5/L5) my answer in that cell reads $DIV/0! since i do not have any data yet thanks -- Message posted via http://www.officekb.com -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
$DIV/0!
Thanks Dave works great!!!!!!
Dave Peterson wrote: =if(l5=0,"",j5/l5) or If I want to divide 2 cells to get an average and there is no # in cell yet the cell where the fomula reads $DIV/0! I would like that cell to be blank. [quoted text clipped - 7 lines] -- Message posted via http://www.officekb.com -- Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
$DIV/0!
On May 6, 3:38*am, "Darts via OfficeKB.com" <u19990@uwe wrote:
Thanks Dave works great!!!!!! Dave Peterson wrote: =if(l5=0,"",j5/l5) or If I want to divide 2 cells to get an average and there is no # in cell yet the cell where the fomula reads $DIV/0! *I would like that cell to be blank. [quoted text clipped - 7 lines] -- Message posted viahttp://www.officekb.com -- Message posted viahttp://www.officekb.com You can also use: IF(ISERROR(J5/L5),"",J5/L5) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
