In your explanation you don't mention that you're wanting the sqrt of A1 to
meet certain conditions but in your formula you're testing the sqrt of A1.

Assuming this formula can be interpreted to be your true intentions:

=IF((ISBLANK(A1),"",(IF((AND(ISNUMBER(A1),(IF(SQR T(A1)SQRT(AVERAGE(A$1:A$54))),1,-1)))

Try it like this:

=IF(A1="","",IF(COUNT(A1),IF(SQRT(A1)SQRT(AVERAGE (A$1:A$54)),1,-1),""))

--
Biff
Microsoft Excel MVP


wrote in message
...
Sorry, should be

=IF((ISBLANK(A1),"",(IF((AND(ISNUMBER(A1),(IF(SQRT (A1)SQRT(AVERAGE(A
$1:A
$54))),1,-1)))