Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can't get "sum" to add up properly
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 -- pgruening ------------------------------------------------------------------------ pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011 View this thread: http://www.excelforum.com/showthread...hreadid=479889 |
#2
|
|||
|
|||
can't get "sum" to add up properly
I bet if you change B6 to "single" it will add correctly. Your IF statement returns a TEXT string (not a number) when B6<"single", (you have the amount enclosed in quotation marks). Remove the quotes and see what happens. =IF(B6="single",20.35,"47.86") should be: =IF(B6="single",20.35,47.86) Good Luck -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=479889 |
#3
|
|||
|
|||
can't get "sum" to add up properly
Thanks Bruce your suggestion worked perfectly! Peter -- pgruening ------------------------------------------------------------------------ pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011 View this thread: http://www.excelforum.com/showthread...hreadid=479889 |
#4
|
|||
|
|||
can't get "sum" to add up properly
I'm glad it worked for you. Thanks for the feedback, it is always appreciated. Cheers! -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=479889 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get excel 2005 to line up damn dollar signs properly. Idiots. | Excel Discussion (Misc queries) | |||
Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
Tab button not working properly | Setting up and Configuration of Excel | |||
Excel 2000 running on Windows XP SP2 does not properly open CSV fi | Excel Discussion (Misc queries) | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions |