| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use ISERROR in functions to hide error values
I am using ISERROR in conditional fromulaes but I am unable to get them to
work on Functions such as Correl, Thankyou for your help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use ISERROR in functions to hide error values
Care to post the formula with CORREL and state the reason why ISERROR is
needed? Daz wrote: I am using ISERROR in conditional fromulaes but I am unable to get them to work on Functions such as Correl, Thankyou for your help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use ISERROR in functions to hide error values
Thanks Aladin
I am using 24 rows in the spreadsheet I then copy in data that varies in amounts of rows used, the formulas are constant so when there is no data the error sign is displayed then using ISERROR the cell is blank then I am able to copy paste special and sort using macros to automate task, I suppose my question is can function formulas have an option so that the cell can be blank when error values are displayed like conditional formulas. Conditional Formula OK =if(ISERROR,(A1/A2)," ",A1/A2) Function F Does Not work=if(ISERROR,CORREL(A1:A5,A8:A12)," ",A1:A5,A8:A12) Thankyou for you help "Aladin Akyurek" wrote: Care to post the formula with CORREL and state the reason why ISERROR is needed? Daz wrote: I am using ISERROR in conditional fromulaes but I am unable to get them to work on Functions such as Correl, Thankyou for your help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use ISERROR in functions to hide error values
One way:
=IF(COUNT(A1:A5),CORREL(A1:A5,A8:A12),"") Daz wrote: Thanks Aladin I am using 24 rows in the spreadsheet I then copy in data that varies in amounts of rows used, the formulas are constant so when there is no data the error sign is displayed then using ISERROR the cell is blank then I am able to copy paste special and sort using macros to automate task, I suppose my question is can function formulas have an option so that the cell can be blank when error values are displayed like conditional formulas. Conditional Formula OK =if(ISERROR,(A1/A2)," ",A1/A2) Function F Does Not work=if(ISERROR,CORREL(A1:A5,A8:A12)," ",A1:A5,A8:A12) Thankyou for you help "Aladin Akyurek" wrote: Care to post the formula with CORREL and state the reason why ISERROR is needed? Daz wrote: I am using ISERROR in conditional fromulaes but I am unable to get them to work on Functions such as Correl, Thankyou for your help |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use ISERROR in functions to hide error values
Thankyou Aladin for your Excellent answer to my problem,
Kind Regards Daz "Aladin Akyurek" wrote: One way: =IF(COUNT(A1:A5),CORREL(A1:A5,A8:A12),"") Daz wrote: Thanks Aladin I am using 24 rows in the spreadsheet I then copy in data that varies in amounts of rows used, the formulas are constant so when there is no data the error sign is displayed then using ISERROR the cell is blank then I am able to copy paste special and sort using macros to automate task, I suppose my question is can function formulas have an option so that the cell can be blank when error values are displayed like conditional formulas. Conditional Formula OK =if(ISERROR,(A1/A2)," ",A1/A2) Function F Does Not work=if(ISERROR,CORREL(A1:A5,A8:A12)," ",A1:A5,A8:A12) Thankyou for you help "Aladin Akyurek" wrote: Care to post the formula with CORREL and state the reason why ISERROR is needed? Daz wrote: I am using ISERROR in conditional fromulaes but I am unable to get them to work on Functions such as Correl, Thankyou for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
| User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Visible rows and functions that work | Excel Worksheet Functions | |||
| 3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
Linear Mode
