Sorry have you specified a condition for values <1 for c12

=IF(C12<1,"",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:

Jacob ... (Hi)

Sorry ... it was when the C12 Value (not D12) got small ... <1.00

Thanks ... 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