Hi, I'd appreciate any help with my problem. I have the following
A B C
1 Benefit Coverage Amount Monthly Premium
2 Employee Life .21/$1,000 $67,000.00 $14.07
3 Dependent Life (if applicable) family $2.00
4 Employee AD&D .04/$1,000$67,000.00 $2.68
5 LTD 2.58/100 $1,529.00 $39.45
6 Dental family 47.86
7 Health family 48.90
8 EAP (if applicable) yes $2.20
9 Total Monthly Premium $60.40
The formula in C9 is =SUM(C2:C8) but it doesn't seem to being adding the values in C6 and C7. The value in C6 comes from the following formula
=IF(B6="single",20.35,"47.86") and the value in C7 comes from a similar formula.
Any suggestions on how to get the total of C2 to C8 in C9
Bookmarks