J
jolver
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
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