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