Try in M7:
=IF(H7=D7+1,CHOOSE(MATCH(D7,{0;5;7;9},1),"",150,20 0,"")+50,CHOOSE(MATCH(D7,{
0;5;7;9},1),"",150,200,""))
Correction to formula suggested, sorry
Try instead in M7:
=IF(AND(D7=6,H7=7),CHOOSE(MATCH(D7,{0;5;7;9},1),"" ,150,200,"")+50,CHOOSE(MAT
CH(D7,{0;5;7;9},1),"",150,200,""))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|