|
| 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
March 29th, 2006, 04:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0! Errors
My formula is as follows:
=(P6/100*55-P30)/(P6/100*55)*100 I keep getting the #DIV/0! error. Can you help? 
|
|
#2
March 29th, 2006, 04:43 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Errors
P6 must be zero or blank. Try this to avoid the error:
=IF(P6=0,0,(P6/100*55-P30)/(P6/100*55)*100) Hope this helps. Pete
|
|
#3
March 29th, 2006, 04:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Errors
Is the value in P6 0? That would explain it, even though you have P6 in the
numerator, 0/0 will still give #DIV/0. -- Regards, Dave "Cindy" wrote: My formula is as follows: =(P6/100*55-P30)/(P6/100*55)*100 I keep getting the #DIV/0! error. Can you help?
|
|
#4
March 29th, 2006, 04:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Errors
What are your values in P6 and P30? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=527637
|
|
#5
March 30th, 2006, 03:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Errors
It works Pete, Thank you so much. I knew someone out there had an answer for
me. I am surprised that microsoft help could not assist me. Thanks again. Cindy "Pete_UK" wrote: P6 must be zero or blank. Try this to avoid the error: =IF(P6=0,0,(P6/100*55-P30)/(P6/100*55)*100) Hope this helps. Pete
|
|
#6
March 30th, 2006, 05:27 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Errors
Thanks for feeding back, Cindy.
Pete
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do i make a sum formula ignore #div/0! errors in the range | shat | Worksheet Functions | 6 | April 22nd, 2006 02:47 PM |
| evaluate #¡VALUE! and #!DIV/0! and other errors.... | jamiguel77 | Worksheet Functions | 1 | February 14th, 2006 07:13 AM |
| This one is a tough one... | markx | Running & Setting Up Queries | 7 | October 5th, 2005 10:21 AM |
| Eliminating #Div/0! Errors | ChuckW | Running & Setting Up Queries | 2 | May 19th, 2005 01:02 AM |
| Formula Help | Diana HIgh School | General Discussion | 6 | November 18th, 2004 05:19 AM |
Linear Mode
