Home |
Search |
Today's Posts |
#1
|
|||
|
|||
function of "+" in the formula "=+(B19/50)*B10
I am trying to determine why the author of the spreadsheet used the plus sign
in the above formula. It doesn't appear to alter the result in any way. What does it do when following the "="? Is it there to make the value positive? Or is there another function? |
#2
|
|||
|
|||
It does nothing.
In article , josh66six wrote: I am trying to determine why the author of the spreadsheet used the plus sign in the above formula. It doesn't appear to alter the result in any way. What does it do when following the "="? Is it there to make the value positive? Or is there another function? |
#3
|
|||
|
|||
This is the result when you enter the formula using, say, the plus sign
on the number pod instead of the equal sign. It's redundant and as JE McG points out, does nothing to the result of the formula. I tested a number of scenarios to see if I could get Excel to change the result of the formula (neg to pos, for instance), with no result. Bottom line is: it's redundant, confusing, and redundant. |
#4
|
|||
|
|||
Ditto to all the above. The expression was probably written by a former Lotus
123 user.|:) "Dave O" wrote: This is the result when you enter the formula using, say, the plus sign on the number pod instead of the equal sign. It's redundant and as JE McG points out, does nothing to the result of the formula. I tested a number of scenarios to see if I could get Excel to change the result of the formula (neg to pos, for instance), with no result. Bottom line is: it's redundant, confusing, and redundant. |
#5
|
|||
|
|||
Lots of Lotus 123 users evolved into this habit. Lotus 123 started its formulas
with + (usually). josh66six wrote: I am trying to determine why the author of the spreadsheet used the plus sign in the above formula. It doesn't appear to alter the result in any way. What does it do when following the "="? Is it there to make the value positive? Or is there another function? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
Function Formula is displayed not results | Excel Worksheet Functions | |||
Can I use TODAY Function in formula without it changing the next . | Excel Discussion (Misc queries) | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |