Reply to thread

Message: [QUOTE="Clipper, post: 6063225"] Let me rephrase. A graphical representation might be better. YTD Actuals = 210 FY Plan = 300 Pay Cumm Rate Act Pay $ Level 1 Plan = 100 100 15% 100 15 Level 2 Plan = 100 200 20% 100 20 Level 3 Plan = 100 300 25% 10 2.5 The forumula I used to get the 1st 100 under Act is this =IF(B2>C5,C5,B2); where B2 is my YTD Actuals (210) and C5 is the 100 under Cumm (cummulative). It is the 2nd and 3rd formulas under the Act column I can't do. [/QUOTE]