How is this one Anthony?

=IF(D1530000,(0.55*D15)-6600,0.33*D15)


Regards
Robert McCurdy
"Anthony" wrote in message
...
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