| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My formula have error, so I remove errors.
I remove error from option, and error show again Div/0. When I try to click
Error checking Excel is not responding. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
My formula have error, so I remove errors.
I remove error from option
I don't know what you mean. Adjust your formula: =IF(B1<0,A1/B1,"") =IF(B1<0,A1/B1,0) Put something sensible in the last position in the IF() statement. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... I remove error from option, and error show again Div/0. When I try to click Error checking Excel is not responding. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
My formula have error, so I remove errors.
I just need to wait 5 minutes.
"Jon Peltier" wrote: I remove error from option I don't know what you mean. Adjust your formula: =IF(B1<0,A1/B1,"") =IF(B1<0,A1/B1,0) Put something sensible in the last position in the IF() statement. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... I remove error from option, and error show again Div/0. When I try to click Error checking Excel is not responding. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I remove multiple 'errors' in Excel error checking, at the same time??? | Excel Discussion (Misc queries) | |||
| Remove errors | Excel Worksheet Functions | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| remove error value when formula exists for empty cells | Excel Worksheet Functions | |||
| remove errors | Excel Discussion (Misc queries) | |||
Linear Mode
