View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

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