|
| 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
February 17th, 2006, 07:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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
February 17th, 2006, 07:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
February 17th, 2006, 07:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
February 17th, 2006, 09:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
May 25th, 2009, 02:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
May 25th, 2009, 02:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
May 25th, 2009, 05:11 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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 |
Linear Mode
