View Single Post
  #3   Report Post  
Andy Wiggins
 
Posts: n/a
Default

Who knows ... what you want to achieve - only you!
It helps to give more information, but ...

... here's an example of how they can be combined:
=IF(AVERAGE(A1:A3)=3,AVERAGE(B1:B3),AVERAGE(C1:C3) )

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"onlineman" wrote in message
...
who knows ?