Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do people use =+A2 or =+d3? What does the "+" reference?
Any information would be greatly appreciated.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do people use =+A2 or =+d3? What does the "+" reference?
The + does nothing in those cases. It means that whoever wrote the formula
has forgotten that they're using Excel, rather than an earlier Lotus spreadsheet package. -- David Biddulph Chris 21222222 wrote: Any information would be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do people use =+A2 or =+d3? What does the "+" reference?
Throwback to Lotus 123 and completely UN necessary.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Chris 21222222" <Chris wrote in message ... Any information would be greatly appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do people use =+A2 or =+d3? What does the "+" reference?
hi
the plus sign is from lotus and is not necessary in excel. in lotus, if you put 2+2 in a cell, lotus does the math and displays 4. in excel you must preceed all math computation with the = sign. and in lotus when using cell references like A2, lotus does not do the math unless you preceed the references with a plus sign ie +A1+A2. it a sign to lotus to do math. some people who have migrated over to excel sometimes still use the + sign in thier formulas. it doesn't hurt but in excel it's not necessary. so if you wish you can remove the plus signs with not harm done. regards FSt1 "Chris 21222222" wrote: Any information would be greatly appreciated. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do people use =+A2 or =+d3? What does the "+" reference?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
can i change "A" to "Name" in reference to columns | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |