| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
Hope you can help me
In the spreadsheet the formula is ie =D283/D190. At this moment all the figures are zero reason why it is returning #DIV/0!. Some of the cells in the tables might stay like this for a while. Is there a formula that I could enter so it doesnt show #DIV/0! but Zero in this cases |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#DIV/0!
One way:
=IF(D190=0,0,D283/D190) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Joe" wrote: Hope you can help me In the spreadsheet the formula is ie =D283/D190. At this moment all the figures are zero reason why it is returning #DIV/0!. Some of the cells in the tables might stay like this for a while. Is there a formula that I could enter so it doesnt show #DIV/0! but Zero in this cases |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#DIV/0!
Try:-=
=IF(ISERROR(D283/D190),"",D283/D190) Mike "Joe" wrote: Hope you can help me In the spreadsheet the formula is ie =D283/D190. At this moment all the figures are zero reason why it is returning #DIV/0!. Some of the cells in the tables might stay like this for a while. Is there a formula that I could enter so it doesnt show #DIV/0! but Zero in this cases |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#DIV/0!
=IF(D190=0,0,D283/D190)
-- David Biddulph "Joe" wrote in message ... Hope you can help me In the spreadsheet the formula is ie =D283/D190. At this moment all the figures are zero reason why it is returning #DIV/0!. Some of the cells in the tables might stay like this for a while. Is there a formula that I could enter so it doesnt show #DIV/0! but Zero in this cases |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
