| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
