Thread
:
Average formula
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
external usenet poster
Posts: 8,856
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
Reply With Quote
Pete_UK
View Public Profile
Find all posts by Pete_UK