| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove error value when formula exists for empty cells
I'm creating a worksheet where I want to carry the formula down the sheet,
eventhough cells are blank. I keep getting error values. I understand why the error values, but I do not want them to display. My formula is: =(B6-B5)/ABS(B5) If tired: =IF(ISERROR(B7-B6)/ABS(B6),"",(B7-B6)/ABS(B6)) and =IF((B8-B7)/ABS(B7)=0,"") but #DIV/0! keeps displaying. Is there an option or conditional format that will give me the option to not display error values? I have to create worksheets for several other formulas and I do not want the error values to display when cells are empty or when dividing by zero. Thanks, Cyrus |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove error value when formula exists for empty cells
Hi Cyrus,
Very Close, you just need to sort out your brackets. =IF(ISERROR((B7-B6)/ABS(B6)),"",(B7-B6)/ABS(B6)) hth Giz "Cyrus" wrote: I'm creating a worksheet where I want to carry the formula down the sheet, eventhough cells are blank. I keep getting error values. I understand why the error values, but I do not want them to display. My formula is: =(B6-B5)/ABS(B5) If tired: =IF(ISERROR(B7-B6)/ABS(B6),"",(B7-B6)/ABS(B6)) and =IF((B8-B7)/ABS(B7)=0,"") but #DIV/0! keeps displaying. Is there an option or conditional format that will give me the option to not display error values? I have to create worksheets for several other formulas and I do not want the error values to display when cells are empty or when dividing by zero. Thanks, Cyrus |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove error value when formula exists for empty cells
IT WORKED!!!! GREAT THANKS!!!
"Gizmo63" wrote: Hi Cyrus, Very Close, you just need to sort out your brackets. =IF(ISERROR((B7-B6)/ABS(B6)),"",(B7-B6)/ABS(B6)) hth Giz "Cyrus" wrote: I'm creating a worksheet where I want to carry the formula down the sheet, eventhough cells are blank. I keep getting error values. I understand why the error values, but I do not want them to display. My formula is: =(B6-B5)/ABS(B5) If tired: =IF(ISERROR(B7-B6)/ABS(B6),"",(B7-B6)/ABS(B6)) and =IF((B8-B7)/ABS(B7)=0,"") but #DIV/0! keeps displaying. Is there an option or conditional format that will give me the option to not display error values? I have to create worksheets for several other formulas and I do not want the error values to display when cells are empty or when dividing by zero. Thanks, Cyrus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Linear Mode
