Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |