Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula construction
Some people use only the = sign and some use =+ why would one want to put a +
sign infront of a value? Does this force negative values to positive? -- Regards Rob |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula construction
Prefixing with a minus would give the ABS of a negative number.
Say B1 had a value of -5 and in A1 we put the formula =-B1 This would return an answer of 5 because minus/minus is plus Putting =+B1 in A1 would return -5 following the same math rule noted above. Mike "Robert-the-Bruce" wrote: Some people use only the = sign and some use =+ why would one want to put a + sign infront of a value? Does this force negative values to positive? -- Regards Rob |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula construction
I figured as much for the - and - issue. What if you are not sure of the
number that will be in the reference cell, and then want the absolute value? If for example if you had varying data or a formula in B1. You would then not know whether to put a + or - in A1. I know this detracts form the original question slightly - just thought it interesting. -- Regards Rob "Mike H" wrote: Prefixing with a minus would give the ABS of a negative number. Say B1 had a value of -5 and in A1 we put the formula =-B1 This would return an answer of 5 because minus/minus is plus Putting =+B1 in A1 would return -5 following the same math rule noted above. Mike "Robert-the-Bruce" wrote: Some people use only the = sign and some use =+ why would one want to put a + sign infront of a value? Does this force negative values to positive? -- Regards Rob |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula construction
There's no need to put a sign there at all so the question doesn't really
arise. If you are unsure if a cell is positive/negative and you want the absolute value whichever it is then it's better to use =ABS(B1). Mike "Robert-the-Bruce" wrote: I figured as much for the - and - issue. What if you are not sure of the number that will be in the reference cell, and then want the absolute value? If for example if you had varying data or a formula in B1. You would then not know whether to put a + or - in A1. I know this detracts form the original question slightly - just thought it interesting. -- Regards Rob "Mike H" wrote: Prefixing with a minus would give the ABS of a negative number. Say B1 had a value of -5 and in A1 we put the formula =-B1 This would return an answer of 5 because minus/minus is plus Putting =+B1 in A1 would return -5 following the same math rule noted above. Mike "Robert-the-Bruce" wrote: Some people use only the = sign and some use =+ why would one want to put a + sign infront of a value? Does this force negative values to positive? -- Regards Rob |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula construction
Excellent thanks
-- Regards Rob "Mike H" wrote: There's no need to put a sign there at all so the question doesn't really arise. If you are unsure if a cell is positive/negative and you want the absolute value whichever it is then it's better to use =ABS(B1). Mike "Robert-the-Bruce" wrote: I figured as much for the - and - issue. What if you are not sure of the number that will be in the reference cell, and then want the absolute value? If for example if you had varying data or a formula in B1. You would then not know whether to put a + or - in A1. I know this detracts form the original question slightly - just thought it interesting. -- Regards Rob "Mike H" wrote: Prefixing with a minus would give the ABS of a negative number. Say B1 had a value of -5 and in A1 we put the formula =-B1 This would return an answer of 5 because minus/minus is plus Putting =+B1 in A1 would return -5 following the same math rule noted above. Mike "Robert-the-Bruce" wrote: Some people use only the = sign and some use =+ why would one want to put a + sign infront of a value? Does this force negative values to positive? -- Regards Rob |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula construction
Fri, 8 Jun 2007 03:34:02 -0700 from Robert-the-Bruce
: Some people use only the = sign and some use =+ why would one want to put a + sign infront of a value? Does this force negative values to positive? No. The leading plus sign has no effect on a numeric argument. People don't necessarily always do things in the most efficient way. Sometimes a textbook will do something silly, and then the people who learned from the textbook follow that 'rule'. I'm not saying there's never any use for a leading + sign, right after the = sign, but I sure can't think of one. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula construction
Fri, 8 Jun 2007 05:09:04 -0700 from Robert-the-Bruce
: I figured as much for the - and - issue. What if you are not sure of the number that will be in the reference cell, and then want the absolute value? If for example if you had varying data or a formula in B1. You would then not know whether to put a + or - in A1. =abs(B1) The Insert Function command is your friend when you don't know the name of the function you want. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula construction
The plus is from the days of Lotus. When you enter the leading +, excel puts
in the = sign itself. Originally intended to make it easy to transition users away from Lotus and some folks never broke the habit. "Stan Brown" wrote: Fri, 8 Jun 2007 03:34:02 -0700 from Robert-the-Bruce : Some people use only the = sign and some use =+ why would one want to put a + sign infront of a value? Does this force negative values to positive? No. The leading plus sign has no effect on a numeric argument. People don't necessarily always do things in the most efficient way. Sometimes a textbook will do something silly, and then the people who learned from the textbook follow that 'rule'. I'm not saying there's never any use for a leading + sign, right after the = sign, but I sure can't think of one. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Efficient Array Formula Construction | Excel Discussion (Misc queries) | |||
Array Construction | Excel Discussion (Misc queries) | |||
formula construction | Excel Discussion (Misc queries) | |||
Construction Loan Interest Formula | Excel Worksheet Functions | |||
Construction Templates | Excel Discussion (Misc queries) |