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
|