Jacob ... (Hi)

This formula worked fine until D12 value got small ... then it returned the
#VALUE error ... ???

Thanks ... I am always learning ... Kha

"Jacob Skaria" wrote:

Try this using IF() and CHOOSE().. Sorry i could not test this..

=IF(F3="Y",D12/CHOOSE(C12,8,16,21.5)*(5/7),IF(F3="N",D12/CHOOSE(C12,8,16,21.5)))

If this post helps click Yes
---------------
Jacob Skaria


"Ken" wrote:

Excel2003 ... The following formula works, but I am thinking it can be
simplified by those intimate with Excel ...

=IF(AND($F$3="Y",C12=1),(D12/8)*(5/7),IF(AND($F$3="Y",C12=2),(D12/16)*(5/7),IF(AND($F$3="Y",C12=3),(D12/21.5)*(5/7),IF(AND($F$3="N",C12=1),D12/8,IF(AND($F$3="N",C12=2),D12/16,IF(AND($F$3="N",C12=3),D12/21.5,""))))))

Thanks ... Kha