Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
Hi everyone,
Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
There is no difference: the + sign is redundant (throw-back to older
spreadsheet packages). Hope this helps. Pete On Apr 15, 11:28*am, Cooz wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
It sure does.
Many thanks. Cooz "Pete_UK" wrote: There is no difference: the + sign is redundant (throw-back to older spreadsheet packages). Hope this helps. Pete On Apr 15, 11:28 am, Cooz wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
You're welcome.
Pete On Apr 15, 11:56*am, Cooz wrote: It sure does. Many thanks. Cooz "Pete_UK" wrote: There is no difference: the + sign is redundant (throw-back to older spreadsheet packages). Hope this helps. Pete On Apr 15, 11:28 am, Cooz wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
The "+" is extraneous. Harmless, but not necessary.
Believe it's just a legacy habit by ex-Lotus users. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cooz" wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
Thank you Max.
That is one clear answer. Cooz "Max" wrote: The "+" is extraneous. Harmless, but not necessary. Believe it's just a legacy habit by ex-Lotus users. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cooz" wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
Welcome, Cooz
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cooz" wrote in message ... Thank you Max. That is one clear answer. Cooz |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
hi
not to seem argumentative, but me and lotus go back to pre-windows days and i don't remember ever having to put plus signs in front of numbers in formulas. i had to put minus signs to denote negative numbers but you have to do that in excel also. regards FSt1 "Max" wrote: The "+" is extraneous. Harmless, but not necessary. Believe it's just a legacy habit by ex-Lotus users. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cooz" wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
But I bet you wrote many formulas like:
+a1+b1 There are lots of old(!) Lotus 123 users who would do: =+a1+b1 thinking that they need both. It wasn't required in 123 and it's not required in xl. FSt1 wrote: hi not to seem argumentative, but me and lotus go back to pre-windows days and i don't remember ever having to put plus signs in front of numbers in formulas. i had to put minus signs to denote negative numbers but you have to do that in excel also. regards FSt1 "Max" wrote: The "+" is extraneous. Harmless, but not necessary. Believe it's just a legacy habit by ex-Lotus users. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cooz" wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz -- Dave Peterson |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
Excel is inconsistent on this. Put XYZ in A1, then =LEN(A1) in B1.
Then put @LEN(A1) in B2, and +LEN(A1) in B3 - why does it leave the + sign in the formula in B3? Pete On Apr 15, 2:20*pm, Dave Peterson wrote: But I bet you wrote many formulas like: +a1+b1 There are lots of old(!) Lotus 123 users who would do: =+a1+b1 thinking that they need both. It wasn't required in 123 and it's not required in xl. FSt1 wrote: hi not to seem argumentative, but me and lotus go back to pre-windows days and i don't remember ever having to put plus signs in front of numbers in formulas. i had to put minus signs to denote negative numbers but you have to do that in excel also. regards FSt1 "Max" wrote: The "+" is extraneous. Harmless, but not necessary. Believe it's just a legacy habit by ex-Lotus users. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cooz" wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz -- Dave Peterson- Hide quoted text - - Show quoted text - |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The meaning of "+".
I don't know why it does, but it does.
But I forgive excel for trying to keep the user's formula as-is. I don't forgive the user for starting with a + <vbg. Pete_UK wrote: Excel is inconsistent on this. Put XYZ in A1, then =LEN(A1) in B1. Then put @LEN(A1) in B2, and +LEN(A1) in B3 - why does it leave the + sign in the formula in B3? Pete On Apr 15, 2:20 pm, Dave Peterson wrote: But I bet you wrote many formulas like: +a1+b1 There are lots of old(!) Lotus 123 users who would do: =+a1+b1 thinking that they need both. It wasn't required in 123 and it's not required in xl. FSt1 wrote: hi not to seem argumentative, but me and lotus go back to pre-windows days and i don't remember ever having to put plus signs in front of numbers in formulas. i had to put minus signs to denote negative numbers but you have to do that in excel also. regards FSt1 "Max" wrote: The "+" is extraneous. Harmless, but not necessary. Believe it's just a legacy habit by ex-Lotus users. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cooz" wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: =IF(+I4991="","",+I4991) Can anyone explain why it should contain these + characters? What is the difference compared to: =IF(I4991="","",I4991)? Thank you, Cooz -- Dave Peterson- Hide quoted text - - Show quoted text - -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Meaning of "--" in formulas | New Users to Excel | |||
What is the meaning of the plus sign in "=+A1"? | Excel Worksheet Functions | |||
What is the meaning of the plus sign in "=+A1"? | Excel Worksheet Functions | |||
In Excel, what is the meaning of " ^ " symbol in a formula? | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |