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
|
|||
|
|||
#DIV/0 error
What I am working with is a simple divide statment using two worksheets.
=('Product'!P20/'Product'!P21) If the answer comes out to zero I get the #DIV/0!, is there a solution to just putting a zero in that cell? Thanks in advance. |
#2
|
|||
|
|||
#DIV/0 error
You should only be getting the divide/overflow when you divide by zero. If
the actual answer is zero, it should put a "0" in the cell. Did I misunderstand the question? -- gevans "Daniell" wrote: What I am working with is a simple divide statment using two worksheets. =('Product'!P20/'Product'!P21) If the answer comes out to zero I get the #DIV/0!, is there a solution to just putting a zero in that cell? Thanks in advance. |
#3
|
|||
|
|||
#DIV/0 error
=IF('Product'!P21=0,0,'Product'!P20/'Product'!P21)
-- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "Daniell" wrote in message ... What I am working with is a simple divide statment using two worksheets. =('Product'!P20/'Product'!P21) If the answer comes out to zero I get the #DIV/0!, is there a solution to just putting a zero in that cell? Thanks in advance. |
#4
|
|||
|
|||
#DIV/0 error
Thanks, I seen what I was doing wrong. I placed a space and another
character on the string. I appreciate the help. "Peo Sjoblom" wrote: =IF('Product'!P21=0,0,'Product'!P20/'Product'!P21) -- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "Daniell" wrote in message ... What I am working with is a simple divide statment using two worksheets. =('Product'!P20/'Product'!P21) If the answer comes out to zero I get the #DIV/0!, is there a solution to just putting a zero in that cell? Thanks in advance. |
#5
|
|||
|
|||
#DIV/0 error
Guys i need URGENT help with this formula
i have 3 cells M62=M63/M64*100 now if both M63 and M64 are 0, I need M62 to display 0, but i know 0/0 gives the DIV/0 error. please let me know if there's a way around this. Many Thanx John |
#6
|
|||
|
|||
#DIV/0 error
All requests are handled the same way here. An URGENT request is sometimes
ignored. -- Don Guillett Microsoft MVP Excel SalesAid Software "John" wrote in message ... Guys i need URGENT help with this formula i have 3 cells M62=M63/M64*100 now if both M63 and M64 are 0, I need M62 to display 0, but i know 0/0 gives the DIV/0 error. please let me know if there's a way around this. Many Thanx John |
#7
|
|||
|
|||
#DIV/0 error
"John" wrote:
i have 3 cells M62=M63/M64*100 now if both M63 and M64 are 0, I need M62 to display 0, but i know 0/0 gives the DIV/0 error. =if(M64=0,0,M63/M64*100) Never mind about M63 being zero. The formula will handle that just fine. ----- original message ----- "John" wrote in message ... Guys i need URGENT help with this formula i have 3 cells M62=M63/M64*100 now if both M63 and M64 are 0, I need M62 to display 0, but i know 0/0 gives the DIV/0 error. please let me know if there's a way around this. Many Thanx John |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I prevent a #DIV/0! error from plotting on a chart | curious | Charts and Charting | 1 | August 26th, 2005 08:35 AM |
Help! I'm getting error messages too much-can't open Resume Wizard | LizLB | General Discussion | 0 | May 3rd, 2005 01:46 AM |
Help, i'm gettiing error: Access has encountered a problem and needs to close... | betsy | General Discussion | 0 | September 14th, 2004 08:20 PM |
INSERT query inside an error handler? | Richard Hollenbeck | Running & Setting Up Queries | 7 | September 11th, 2004 02:31 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |