Existing formula

  • Thread starter Thread starter wwhite
  • Start date Start date
W

wwhite

I'm working with a spreadsheet that was built by someone else and cam
across a formula in some of the cells that I'm puzzled by. The formul
begins with "=", but the next character is "+", then a reference t
another worksheet and cell. The "+" is what I'm wondering about,
haven't seen it used in this context before, can someone help me ou
here? Some examples of what I'm looking at are:

=+Inputs!G9

=+H17-R20

Thanks, wwhit
 
It's an unnecessary character that is there because the person that created the
formula may well have previously worked in Lotus. Excel allows you to creat e
formula starting with a + and inserts the = automatically, , but unless the
character was a minus sign it does nothing of any relevance and can be discarded
with no worry.
 
Back
Top