Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to decrease value of cell
Need to be able to have cell B4 decrease by 1 every 30 days until it reaches 0
I would also like to be able to take values in A17 move up one if A16 is empty. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to decrease value of cell
One way...............
enter in B4 ....=30-(TODAY()-40116)/30 40116 is the number for today the 30th of october tomorrow the formula will give you 30 -(40117-40116)/30 or 30 - 1/30 the day after it will be 30 - 2/30 you can format the cell to have a few decimals to see where you are. or you can add a "round()" function if you need whole numbers The second part of your question would have to be done with a macro and you would need to specify when or how often. I.e. check once per day? Greetings from New Zealand "Flyboy" wrote in message ... Need to be able to have cell B4 decrease by 1 every 30 days until it reaches 0 I would also like to be able to take values in A17 move up one if A16 is empty. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to decrease value of cell
Without using code, you'll have to assign *other* cells to contain your
"starting points", for values and dates. Say A1 for starting value, and A2 for starting date. Then try something like this in B4 for question #1: =MAX(A1-IF(TODAY()=A2,LOOKUP(TODAY()-A2,{0,30,60,90,120,150,180,210,240;0,1,2,3,4,5,6,7 ,8}),0),0) And something like this in A17 for #2: =1*(A16="")+A1 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Flyboy" wrote in message ... Need to be able to have cell B4 decrease by 1 every 30 days until it reaches 0 I would also like to be able to take values in A17 move up one if A16 is empty. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DECREASE CELL VALUES BY 50% | Excel Worksheet Functions | |||
decrease formula bar | Excel Discussion (Misc queries) | |||
Decrease Decimal in a combined text/formula cell | Excel Worksheet Functions | |||
Decrease Decimal in a combined text/formula cell | Excel Worksheet Functions | |||
Decrease Decimal in a combined text/formula cell | Excel Worksheet Functions |