Thread: Average formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Average formula

Ah yes, I missed the S2 divisor - good job you are on the case, Mike
<bg

Pete

On Sep 17, 9:47*am, Mike H wrote:
Another way would be to check for zero in those 2 cells

=IF(OR(H2=0,S2=0),"",(F2*((T2/S2)*4.54))/H2)

Mike