Prev: formula to calculate amount of hours downtime spent in days
Next: Bond premium amortization using the constant yield method
From: metude on 26 Jan 2010 13:29
If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not
quote), i'm taking an #Value error... How can i solve this issue?
From: Luke M on 26 Jan 2010 13:35
=SUM(A1:B1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"metude" wrote:

> If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not
> quote), i'm taking an #Value error... How can i solve this issue?
From: trip_to_tokyo on 26 Jan 2010 13:39
Which result are you trying to achieve?

If you want a result of:-

r1

- then uses the following formula in cell C 1:-

=CONCATENATE(A1,B1)

Please hit yes if my comments have helped.

Thanks.

"metude" wrote:

> If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not
> quote), i'm taking an #Value error... How can i solve this issue?
From: "David Biddulph" groups [at] on 26 Jan 2010 14:50
If you want to concatenate, not add, it's =A1&B1
--
David Biddulph

"metude" <metude(a)discussions.microsoft.com> wrote in message
news:6FF1F94D-4EFE-4753-811B-E404CDEA57DE(a)microsoft.com...
> If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not
> quote), i'm taking an #Value error... How can i solve this issue?


 | 
Pages: 1
Prev: formula to calculate amount of hours downtime spent in days
Next: Bond premium amortization using the constant yield method