the first part worked charging at the higher rate if there was a "Y" in
column C just the last bit didn't work. it charged at the lower rate when
column C was blank & there was a zero in column A instead of any quantity
greater than zero. any suggestions?

"Pete_UK" wrote:

You're welcome.

Pete

On Jul 6, 10:29 am, mahone wrote:
thanks i'll give this a go when i get back to work next week. hopefully it'll
work & i'll learnt something else.