Thread: Need blank if no values in range getting value at the mo'
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mifty Mifty is offline
external usenet poster
  
Posts: 99
Default Need blank if no values in range getting value at the mo'
Hi everyone,

Could anyone help and tell me what's the matter with this please?


=if(p1:p4<,"",AVERAGE(IF(P1:P40,P1:P4,FALSE))

Scratching my head - feels like a Friday not a Thursday :-)

--
Mifty
Reply With QuoteReply With Quote