benefit

Can anyone help me correct the following formula: =IF(C2>100,IF(T2="Change of Ropa",ROUNDUP(VLOOKUP(DATE(2006,1,1),$Q$2:$R$28,2,0)*1.86,-1)+G2),IF(C2>100,IF(OR(T2={"Superannuation","Appointment","Annual Increment","Enhancement of Qualification","10 Years' Benefit","18 Years' Benefit","20 Years'...

Hi All, I am working on file which has benefits start date for example 01/01/17 and finish date of 30/04/7 with a benefit value $10,000 and in other cases start date 01/10/17 an end date 30/10/18 Benefit value $12,000. I am trying to capture cost by year and month on pro rata basis. So I can...

Long-time lurker, first time poster! I need help developing a formula that would allow an employee to enter their age, desired benefit $ amount, and spit out a monthly premium cost. I have a table created to pull the necessary data from. Each row is the $ benefit amount (from $10,000 to...

Hi everyone I'm trying to complete a spreadsheet for our group benefits. Our one benefit is based on a graded schedule(66.67% of the first 6000 monthly earnings, 55% of the next 3000 monthlyearnings, then 40% of the remaining earnings up to a maximum benefit of 8000per month. I have a...

=IFERROR(MATCH(SUMIFS('Benefit Export'!$K:$K,'Benefit Export'!$B:$B,G$4,'Benefit Export'!$H:$H,1,'Benefit Export'!$E:$E,"Member",'Benefit Export'!$I:$I,"Individual"),Current!Dental_Max,0),1)