Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Desperately Needed!
Using four cells, this is what I'm trying to accomplish:
Cell 1 is the input cell, ex., I want to be able to input any number into this cell, but have a limit of 10,000 with the excess (whatever that may be OVER 10,000) going into cell 3 automatically. Cell 2 should be calculated at 40% (or .40) of cell 1 (which would have a value of between 1 and 10,000. NOW...With the excess in cell 3, cell 4 should be calculated at 25% (or .25) I've done it before, but can't remember for my very life HOW I accomplished this WITHOUT having to physically place the excess amount over 10,000 into cell 3 manually. Please HELP!!!!!!! Wobert |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Desperately Needed!
you need another cell, the input cell can't have a formula, just the number,
then you do =if(a110000,10000,a1) that gives you the imput number, or 10000, then in another cell the excess, or 0 =if(a110000,a1-10000,0) "ThunderStorm Studio" wrote: Using four cells, this is what I'm trying to accomplish: Cell 1 is the input cell, ex., I want to be able to input any number into this cell, but have a limit of 10,000 with the excess (whatever that may be OVER 10,000) going into cell 3 automatically. Cell 2 should be calculated at 40% (or .40) of cell 1 (which would have a value of between 1 and 10,000. NOW...With the excess in cell 3, cell 4 should be calculated at 25% (or .25) I've done it before, but can't remember for my very life HOW I accomplished this WITHOUT having to physically place the excess amount over 10,000 into cell 3 manually. Please HELP!!!!!!! Wobert |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Desperately Needed!
Or =MIN(A1,10000) and =MAX(0,A1-10000)
-- David Biddulph "dlw" wrote in message ... you need another cell, the input cell can't have a formula, just the number, then you do =if(a110000,10000,a1) that gives you the imput number, or 10000, then in another cell the excess, or 0 =if(a110000,a1-10000,0) "ThunderStorm Studio" wrote: Using four cells, this is what I'm trying to accomplish: Cell 1 is the input cell, ex., I want to be able to input any number into this cell, but have a limit of 10,000 with the excess (whatever that may be OVER 10,000) going into cell 3 automatically. Cell 2 should be calculated at 40% (or .40) of cell 1 (which would have a value of between 1 and 10,000. NOW...With the excess in cell 3, cell 4 should be calculated at 25% (or .25) I've done it before, but can't remember for my very life HOW I accomplished this WITHOUT having to physically place the excess amount over 10,000 into cell 3 manually. Please HELP!!!!!!! Wobert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Desperately need a command or something! | Excel Discussion (Misc queries) | |||
DESPERATELY NEED HELP | Excel Discussion (Misc queries) | |||
Desperately Seeking Offset Formula!! | Excel Discussion (Misc queries) | |||
Desperately need help!! | New Users to Excel | |||
Desperately need help with 3 calculations | Excel Worksheet Functions |