Say your values are in A2, B2 and C2. C2 is the one that shows postage.
Your formula is: =SUM(A2:C2). If these are not in adjacent cells, say in
B2, F2 and H2, you may have to use =IF(H2="Free",B2+F2,B2+F2+H2)
"ianonline" wrote:
Hello,
Can anyone 'in the know' advise how to add cell1 + cell2 + cell3 and
get a numerical result when cell3 may contain a word. Cell3 represent
postage and the word, if the order value is is high enough, would be
FREE.
It's not easy as it looks, it seems!
Thank you.
Ian
--
ianonline
------------------------------------------------------------------------
ianonline's Profile: http://www.excelforum.com/member.php...o&userid=34279
View this thread: http://www.excelforum.com/showthread...hreadid=552764