Thread: Nested IF Statements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] steve@stevefitzgerald.net is offline
external usenet poster
  
Posts: 4
Default Nested IF Statements
Sorry, should be

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