How do you add figure with a word in?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ianonline - 16 Jun 2006 19:01 GMT

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

Signature

ianonline

Reply to this Message

tim m - 16 Jun 2006 19:31 GMT

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?

> Hello,
>
[quoted text clipped - 8 lines]
>
> Ian

Reply to this Message

kassie - 16 Jun 2006 19:35 GMT

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)

> Hello,
>
[quoted text clipped - 8 lines]
>
> Ian

Reply to this Message

JMB - 17 Jun 2006 03:16 GMT

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.

> Hello,
>
[quoted text clipped - 8 lines]
>
> Ian

Reply to this Message