If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Want to replace cells that read "#DIV/0" with another value
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! |
#2
|
|||
|
|||
Want to replace cells that read "#DIV/0" with another value
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! |
#3
|
|||
|
|||
Want to replace cells that read "#DIV/0" with another value
Works perfectly. Thanks!
"financeman500" wrote in message news 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! |
#4
|
|||
|
|||
Want to replace cells that read "#DIV/0" with another value
no problem, any time
"Stacey" wrote: Works perfectly. Thanks! "financeman500" wrote in message news 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do i replace empty cells with zeros after a cross tab query | fishcakes | General Discussion | 6 | November 18th, 2008 07:25 PM |
How can I replace a range of blank cells with a 0 | Replacing blank cells | General Discussion | 1 | August 19th, 2005 12:01 AM |
Help adding text values | Texas-DC_271 | Worksheet Functions | 5 | January 15th, 2005 09:29 AM |
Another set of Read Only woes | feetintheair | General Discussion | 2 | November 14th, 2004 09:35 PM |
Formatting cells to read time in 1/100ths | John Wright | Setting up and Configuration | 1 | March 9th, 2004 11:38 PM |