Logical formula in multiple criteria

Originally Posted by mehmetcik

Formula for H7

Formula:

=MAX(H7-IF(E7=$C$1,$C$2,$D$2),0)

Formula for M7

Formula:

=MAX(L7*24-IF(E7=$C$1,$C$3,$D$3),0)

Dear Mehmetcik

many thanks...
it works too......
thank you so much.... appreciated your efforts...
regards
amul