2010/10/22 Ashish Jain ashishj...@openexcel.com
>
> 3. In cell A10, use the formula below(any version of excel):
> =If(A9<=0.5,2,If(A9<=0.8,3,If(A9>=0.8,4,3)))
>
an alternative to the formula of Ashish Jain for point 3.
=MAX(FREQUENCY(A9,{0.5;0.8})*{2;3;4})
regards
r
--
---
Hi Dean,
Here is the solution:
1. & 2. Just use this formula
Excel 2007 or Excel 2010
=IFERROR((I55/I54)*3600," ")
Excel 2003 or older
=IF(ISERROR((I55/I54))," ",(I55/I54)*3600)
3. In cell A10, use the formula below(any version of excel):
=If(A9<=0.5,2,If(A9<=0.8,3,If(A9>=0.8,4,3)))
4. Watch a
