Point Assessment Calc?

Tech-Archive recommends: Fix windows errors by optimizing your registry


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?:confused:

Lost, and looking for found!

Thanks:)


--
jolver
------------------------------------------------------------------------
jolver's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30462
View this thread: http://www.excelforum.com/showthread.php?threadid=501298

.

Relevant Pages

  • Re: adapting the findnext function
    ... > in via a lookup, is there anyway to make excel think they are just there ... > chrisrowe_cr's Profile: ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: working with IF statements
    ... I have some programming experience ... but not a whole lot with excel so this was just a thought. ... matty_g's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23954 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: convert time in xxxx format to xx:xx
    ... If you subtract your 00:51 ... If you are unfamiliar with how to create a VBA macro and then execute ... With Excel running, hit ALT-F11. ... This opens the VBA editor. ...
    (microsoft.public.excel.misc)
  • Re: Converting Numbers to Time
    ... > why excel assumes that result of adding or subtracting two dates should ... mangesh_yadav's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10470 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Autosave:: off
    ... FROM EXCEL AGAIN UNTIL YOU TURN IT BACK ON!* ... funkymonkUK ... funkymonkUK's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18135 ... Prev by Date: ...
    (microsoft.public.excel.programming)