I think i need an if and maybe something else
 

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

I think i need an if and maybe something else
 

in D15:

=IF(AND(D50,D5=<30000),0.33*D5,IF(D530000,0.33*D 5+0.55*(D5-30000),))

hope I didn't miss anything
;-)


On 24 Mar, 08:39, Anthony wrote:
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

I think i need an if and maybe something else
 

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

"Anthony" wrote:

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

I think i need an if and maybe something else
 

thanksfor yuour assistance

"Jarek Kujawa" wrote:

in D15:

=IF(AND(D50,D5=<30000),0.33*D5,IF(D530000,0.33*D 5+0.55*(D5-30000),))

hope I didn't miss anything
;-)


On 24 Mar, 08:39, Anthony wrote:
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

I think i need an if and maybe something else
 

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