If Isnumber Question

[Nolan0211]

I want to only return a correlation number if there are numbers in both B245 and KA 245. I assume I would use an IF and an AND argument, but can't figure it out. This is what I have so far.

=IF(ISNUMBER(B245),CORREL(B245:B256,$KA$245:$KA$256),"X")

 

[VoG]

Try

=IF(AND(ISNUMBER(B245),ISNUMBER(KA245)),CORREL(B245:B256,$KA$245:$KA$256),"X")

 

[Andrew Poulsom]

Is it?

=IF(AND(ISNUMBER(B245),ISNUMBER(KA245)),CORREL(B245:B256,$KA$245:$KA$256),"X")

 

[Gerald Higgins]

Hi, welcome to the board.

Perhaps

=IF(and(ISNUMBER(B245),ISNUMBER(KA245)),CORREL(B245:B256,$KA$245:$KA$256),"X")

or maybe

=IF(ISNUMBER(B245+KA245),CORREL(B245:B256,$KA$245:$KA$256),"X")

Personally I'm not familiar with the CORREL function, so I'll assume you've got that bit right.

 

[Nolan0211]

Yep those work. Thanks guys!