Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Point Assessment Calc?
Hello - I am new to excel and using "if statements", but I was told that I could probably use excel to determine the total points assessed based on date values. My rules are this: 90 days with no point = subtract oldest point then every 30 subsequent days without a point = subtract next oldest point and/or subtract oldest point that was assessed 365 days ago. Is this possible to do in excel? Lost, and looking for found! Thanks:) -- jolver ------------------------------------------------------------------------ jolver's Profile: http://www.excelforum.com/member.php...o&userid=30462 View this thread: http://www.excelforum.com/showthread...hreadid=501298 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter Chart Data Point Highlighting | Charts and Charting in Excel | |||
Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
format inplied decimal point | Excel Discussion (Misc queries) | |||
how to produce horizontal line chart of point est & 95% ci's | Charts and Charting in Excel | |||
decimal point override does not work | Excel Discussion (Misc queries) |