I wonder if anyone can help - been struggling with this one for a while and only getting so far..
I'm trying to get a formula to work out salary increments that go up a spine point every year, but this increase can either
be on a fixed date or on a start date anniversary. so my statement looks at the start date and end dates of each period and
if it matches one of the dates specified in a range elsewhere it should increase the spine point - easy enough.
However this is complicated by the fact that we don't have a spine point 19, so I have to build in another IF statement
along the lines of "if answer=19 then use previous cell plus 2 otherwise previous cell plus 1"
It works in the
sense that it jumps from 18 - 20, but for some reason it then can't continue so rather than the next cell going to 21 it
reverts to 0!
help - it must be something in my logic but i can't get my head round it any suggestion would be
here is part of the formula where the error is found - The refer options are all to do with looking up dates (can't use a
lookup as it contains other data that screws it up)..