How do I use ISERROR in functions to hide error values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Care to post the formula with CORREL and state the reason why ISERROR is
needed?
 
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
 
Thankyou Aladin for your Excellent answer to my problem,
Kind Regards
Daz
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISERROR on VLOOKUP 3
if(iserror()) question 2
using if iserror on aonther sheet 2
Need a ) somewhere in ISERROR formula but don't know where to put it 3
Check for NON-presence of a string in another string 3
iserror 4
Iserror with if(or & Vlookups 5
Using ISERROR to Solve #DIV/0 in a formula 13

Back
Top