Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
I am working with a model where the reference formulas are not just simple
references (e.g., "=A1") rather they all have "+" signs, (e.g., "=+A1"). Is there a difference? If so, what is the purpose for the "+"? Thanks |
#2
|
|||
|
|||
As I understand it, the "+" serves no purpose and is usually the result of
people entering formulas incorrectly, ie if you enter a formula as +A1 then re-select the cell you will see that the formula has been entered by Excel as =+A1 I believe, (although I have never used it), that Lotus 123 used the + as the start of a formula and Excel is tollerant of it but does not use it. -- HTH Sandy Replace@mailinator with @tiscali.co.uk "Vlookup help" wrote in message ... I am working with a model where the reference formulas are not just simple references (e.g., "=A1") rather they all have "+" signs, (e.g., "=+A1"). Is there a difference? If so, what is the purpose for the "+"? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |