How do you add figure with a word in?

[ianonline]

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

[tim m]

I just did a quick test of adding three cells 10,FREE,5 and the summed answer
was 15 which is as expected. I assume that FREE means it would be equal to a
zero value. What kind of result are you getting that is causing you problems?

"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
>
>

[kassie]

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
>
>

[JMB]

As Tim said, use the SUM function, it will ignore "FREE". You will get an
error if you just use =cell1+cell2+cell3.

Use =SUM(cell1, cell2, cell3) if they are not adjacent. =SUM(cell1:cell3)
if they are adjacent.


"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
>
>