| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Want to replace cells that read "#DIV/0" with another value
no problem, any time
"Stacey" wrote: Works perfectly. Thanks! "financeman500" wrote in message ... Hi Stacey, You can use the if command in your cell example =IF(C13,C13/C8,0) "Stacey" wrote: I have a chart where certain field is computed based on the content of other fields (not unsual). However, it is actually an average field and the fields it uses to compute the average are autopopulated from data in another worksheet. Sometimes all the valus are "0" so when it tried to take the average it gives me a "#DIV/0" error. Is there a way I can get it to display "0" or "n/a" instead of "#DIV/0" in these specific cells when this error arises? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the command to replace a cell's formula with it's value? | Excel Discussion (Misc queries) | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| Show cells have been read - linked | Excel Discussion (Misc queries) | |||
| How do I have a IF AND formula read 2 different cells to be true | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
