Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Pls let me know what are the diferrent with or without the simbol '+' in this formula: =+'sheet1!'A1 ='sheet'!A1 tq. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
There is no difference. If no sign is input, the default is positive. This may be a 'feature' carried over for the benefit of 123 users, where the + sign was used instead of = (I believe). Andy. "Param" wrote in message ... Hi, Pls let me know what are the diferrent with or without the simbol '+' in this formula: =+'sheet1!'A1 ='sheet'!A1 tq. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
tq
"Andy" wrote: Hi There is no difference. If no sign is input, the default is positive. This may be a 'feature' carried over for the benefit of 123 users, where the + sign was used instead of = (I believe). Andy. "Param" wrote in message ... Hi, Pls let me know what are the diferrent with or without the simbol '+' in this formula: =+'sheet1!'A1 ='sheet'!A1 tq. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If someone makes a change does this automatically refresh? | Excel Discussion (Misc queries) | |||
Autofit makes rows too tall | Excel Discussion (Misc queries) | |||
Autofit makes rows too tall | Excel Discussion (Misc queries) | |||
Can Excel Choose from a List What Makes a Particular Total? | Excel Discussion (Misc queries) | |||
Creating a function that makes a negative number a zero | Excel Discussion (Misc queries) |