Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 149
Default helpp

i have an amount of 265000000
and i would like to take into considerattion the following :

if this amount is between 0 and 6000000......then 6000000*2%

if this amount is above 6000000 and also reach to 9000000....then
6000000*2%+9000000*5%

if this amount is above 6000000 and 9000000 and also reach to
15000000...then 6000000*2%+9000000*5%+15000000*7%

if this amount is above 6000000 and 9000000 and 15000000 and also reach to
30000000...then 6000000*2%+9000000*5%+15000000*7%+30000000*11%

if this amount is above 6000000 and 9000000 and 15000000 and 30000000 and
also reach to 60000000....then
6000000*2%+9000000*5%+15000000*7%+30000000*11%+600 00000*15%

if this amount is above 60000000 and 9000000 and 15000000 and 30000000 and
60000000 and also reach to 120000000 OR ABOVE...then
6000000*2%+9000000*5%+15000000*7%+30000000*11%+600 00000*15% +the remaining
number *20%


what should i do in order to make them in a formula in a single cell ????
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"