| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Div/0 error
Hi,
When I use the following formula =(a1-a2)/ABS(a1) Any time A1=0, I receive a devide by 0 error. How can I change the formula to show 100% instead? Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Div/0 error
Hi Vic,
Here's one way: =IF(A1=0,1,(A1-A2)/ABS(A1)) -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... Hi, When I use the following formula =(a1-a2)/ABS(a1) Any time A1=0, I receive a devide by 0 error. How can I change the formula to show 100% instead? Thank you |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Div/0 error
Than you when I change the 1 to 100% it shows a 100% as the result,
but if I change cell A1 to $5 instead of $0 The result still stays 100% It doesn't change to the real result "Rob Bovey" wrote: Hi Vic, Here's one way: =IF(A1=0,1,(A1-A2)/ABS(A1)) -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... Hi, When I use the following formula =(a1-a2)/ABS(a1) Any time A1=0, I receive a devide by 0 error. How can I change the formula to show 100% instead? Thank you |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Div/0 error
Hi Vic,
It sounds like you may not have your workbook set to calculate automatically. If you're using Excel 2003 or earlier, choose Tools Options Calculation from the Excel menu. Make sure the Automatic option in the upper left corner is selected, then click OK and save your workbook. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... Than you when I change the 1 to 100% it shows a 100% as the result, but if I change cell A1 to $5 instead of $0 The result still stays 100% It doesn't change to the real result "Rob Bovey" wrote: Hi Vic, Here's one way: =IF(A1=0,1,(A1-A2)/ABS(A1)) -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... Hi, When I use the following formula =(a1-a2)/ABS(a1) Any time A1=0, I receive a devide by 0 error. How can I change the formula to show 100% instead? Thank you |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Div/0 error
The problemis some columns in the same worksheet work and some dont'. Some
calculate and some don't update and don't work "Rob Bovey" wrote: Hi Vic, It sounds like you may not have your workbook set to calculate automatically. If you're using Excel 2003 or earlier, choose Tools Options Calculation from the Excel menu. Make sure the Automatic option in the upper left corner is selected, then click OK and save your workbook. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... Than you when I change the 1 to 100% it shows a 100% as the result, but if I change cell A1 to $5 instead of $0 The result still stays 100% It doesn't change to the real result "Rob Bovey" wrote: Hi Vic, Here's one way: =IF(A1=0,1,(A1-A2)/ABS(A1)) -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... Hi, When I use the following formula =(a1-a2)/ABS(a1) Any time A1=0, I receive a devide by 0 error. How can I change the formula to show 100% instead? Thank you |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Div/0 error
"Vic Abrahamian" wrote in message
... The problemis some columns in the same worksheet work and some dont'. Some calculate and some don't update and don't work Hi Vic, Check the input cells for the formulas that don't update and make sure they are not formatted as text. The Format Cells Number tab will have the Text entry selected if this is the case. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... The problemis some columns in the same worksheet work and some dont'. Some calculate and some don't update and don't work "Rob Bovey" wrote: Hi Vic, It sounds like you may not have your workbook set to calculate automatically. If you're using Excel 2003 or earlier, choose Tools Options Calculation from the Excel menu. Make sure the Automatic option in the upper left corner is selected, then click OK and save your workbook. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... Than you when I change the 1 to 100% it shows a 100% as the result, but if I change cell A1 to $5 instead of $0 The result still stays 100% It doesn't change to the real result "Rob Bovey" wrote: Hi Vic, Here's one way: =IF(A1=0,1,(A1-A2)/ABS(A1)) -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Vic Abrahamian" wrote in message ... Hi, When I use the following formula =(a1-a2)/ABS(a1) Any time A1=0, I receive a devide by 0 error. How can I change the formula to show 100% instead? Thank you |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Div/0 error
HI,
Thank you, but when I change the 0 in cell a1 to another number the result doesn't change. I di "Vic Abrahamian" wrote: Hi, When I use the following formula =(a1-a2)/ABS(a1) Any time A1=0, I receive a devide by 0 error. How can I change the formula to show 100% instead? Thank you |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Div/0 error
Vic
Did you try Rob's last suggestion? You can also try pressing F9 to recalcute the worksheet (in case it is manual). Here, it works fine whichever way I go... unless there is something else going on which you have not disclosed. -- Robert Author of RibbonX: Customizing the Office 2007 Ribbon: LATEST INTERACTIVE TUTORIAL: http://www.msofficegurus.com/videos/...p_HT_Chart.asp FORUM: http://www.msofficegurus.com/forum/ |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Div/0 error
But the problem is some of the columns work and some don't in the same
worksheet. "Robert Martim, Excel" wrote: Vic Did you try Rob's last suggestion? You can also try pressing F9 to recalcute the worksheet (in case it is manual). Here, it works fine whichever way I go... unless there is something else going on which you have not disclosed. -- Robert Author of RibbonX: Customizing the Office 2007 Ribbon: LATEST INTERACTIVE TUTORIAL: http://www.msofficegurus.com/videos/...p_HT_Chart.asp FORUM: http://www.msofficegurus.com/forum/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| Form Err.Raise error not trapped by entry procedure error handler | Excel Programming | |||
| Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Hybrid Mode
