| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Applying Percent Decrease Across Set Periods
I have a column which includes dates when items were purchased. I have used the DATEDIF function to find the number of years between that date and today's date. I now want to decrease the purchase amount 10% for every year calculated via the DATEDIF function. Any ideas, is this possible, why can't I think...? -- Hunt&Peck ------------------------------------------------------------------------ Hunt&Peck's Profile: http://www.excelforum.com/member.php...o&userid=32961 View this thread: http://www.excelforum.com/showthread...hreadid=527873 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Applying Percent Decrease Across Set Periods
Hi!
= purchase_amount*(1-result_of_Datedif_formula/10) A1 = some date B1 = Datedif formula C1 = purchase amount =C1*(1-B1/10) Biff <Hunt& "Peck" wrote in message ... I have a column which includes dates when items were purchased. I have used the DATEDIF function to find the number of years between that date and today's date. I now want to decrease the purchase amount 10% for every year calculated via the DATEDIF function. Any ideas, is this possible, why can't I think...? -- Hunt&Peck ------------------------------------------------------------------------ Hunt&Peck's Profile: http://www.excelforum.com/member.php...o&userid=32961 View this thread: http://www.excelforum.com/showthread...hreadid=527873 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two columns percent in third | New Users to Excel | |||
| Currency, Percent and Comma Style buttons | Excel Worksheet Functions | |||
| Percent Change | Excel Discussion (Misc queries) | |||
| Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
| Calculating number of periods when payment amount changes | Excel Worksheet Functions | |||
Linear Mode
