How to formulate a cell based on the table of contribution

[gerard_gonzales33]

Hi

Need help to correct my formula. I try using this formula in order to plot the contribution of the employer based on the salary of an employee:
=INDEX(contri table!$F$5:$F$33,MATCH($A4,TRIM(LEFT(contri table!$B$5:$B$33,FIND("-",contri table!$B$5:$B$33)-1))*1,1)) but it always gives me a #N/A result, what seems to be problem? Hope you could enlighten me bout this.


Thank you.

[gerard_gonzales33]

This is to re-post my query. Thanks again.

[vlady]

hello kabayan try
this will give you the Total monthly premium.
=MIN(VALUE(LEFT(A4,LEN(A4)-3)&"00")*0.25,875)

just include /2 to divide the TMP for Employee and Employer

=MIN(VALUE(LEFT(A4,LEN(A4)-3)&"00")*0.25,875)/2

[gerard_gonzales33]

Wow Thank you Kabayan your a big help. Am lost where can I find the "solved" button or icon?

[vlady]

Your very much welcome. I'll mark it solved for you and it's located in

Thread Tools from the menu link above