Hi All

JUst a bit out of my depth
lets assume we are refering to column D
All cells in row 5 will contain values derived from elsewhere that will be
from zero to around 55000. ie D5 46560

Cell D15 needs to calcutate the following ,0.33 times value of D5 from 0 to
30000 plus .55 for all above 30000

ie 46560 result is .33*30000 plus .55*16560= 19008

or
for 23450 result is just 23450*.33 = 7738

hope someone can be of assistance, always had greatly appreciated help here
before

cheers

anthony