#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. |
#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. |
#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. |
#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. |
#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 |
#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 |
#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 |
All times are GMT +1. The time now is 02:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com