| Home |
| Search |
| Today's Posts |
|
#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 |
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
