Formula preceded by + sign

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to understand and maintain a spreadsheet with existing formulas. There
is one type of entry/notation, which is new to me the formula contains a
+-sign as follows:
=+G15*1.05
Can anybody tell me what the efect and/or significance of the "+"-sign is?
Many thanks,
Roland
 
It's redundant and generally a hangover from when someone used to use Lotus
123. In Lotus you used to enter data as just +A1 and can do the same in
Excel, but Excel will make it =+A1. You can just delete them and not worry,
or leave them and not worry.
 
It's a holdover from Lotus notation and is completely meaningless in
Excel.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possibly Too Many Arguments 7
Using SUMPRODUCT with a VLOOKUP 4
excel 2003 subtract function 2
Clever formula required (to find the word directly preceding mychosen word) 3
convert this M5447270!V30 to a formula, add somehow the = sign 11
Positive sign 2
Text Formula 3
Simplify this formula 8

Back
Top