I think i need an if and maybe something else

[Anthony]

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

 

[Jarek Kujawa]

in D15:

=IF(AND(D5>0,D5=<30000),0.33*D5,IF(D5>30000,0.33*D5+0.55*(D5-30000),))

hope I didn't miss anything
;-)

 

[yshridhar]

=IF(D5<=30000,D5*0.33,30000*0.33+(D5-30000)*0.55)
best wishes
Sreedhar

 

[Anthony]

thanksfor yuour assistance

in D15:

=IF(AND(D5>0,D5=<30000),0.33*D5,IF(D5>30000,0.33*D5+0.55*(D5-30000),))

hope I didn't miss anything
;-)

 

[Robert McCurdy]

How is this one Anthony?

=IF(D15>30000,(0.55*D15)-6600,0.33*D15)


Regards
Robert McCurdy