| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Addition Error
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Addition Error
=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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Addition Error
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Addition Error
If you want to concatenate, not add, it's =A1&B1
-- David Biddulph "metude" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| addition error code is 1E+05. What does that mean? | Excel Discussion (Misc queries) | |||
| Excel 2007 SP2 Addition of Negative Numbers Error | Excel Discussion (Misc queries) | |||
| autosum addition error | Excel Discussion (Misc queries) | |||
| Excel Addition Error | Excel Discussion (Misc queries) | |||
| Error in Addition and Subtraction | Excel Discussion (Misc queries) | |||
Linear Mode
