Hi all,
I have the following table of data, and I'm trying to extract the amount payable in column A, depending upon both a persons salary and the start and finish date from the range in column D & E. So for example if a persons salary was $75k on 1/8/12 the amount payable would be $80.00 (if that makes sense)
My array formula is
Please Login or Register to view this content.
However the result in all instances is $190 which is incorrect, any idea where I'm going wrong in the formula?HTML Code:
Many thanks
David
Bookmarks