What does is mean when I see a "+" beginning a formula

  • Thread starter Thread starter cefwork
  • Start date Start date
C

cefwork

What does is mean when I see a "+" beginning a formula. =+j2-g4/(h4). What
does the "+" do?
 
It does nothing. It means that the author of the formula has forgotten that
he is using Excel, and not an old Lotus spreadsheet.
 
Absolutely nothing, now. It's a leftover from earlier programming languages
(or older programmers!) when you had to include the sign (such as in Lotus
notes). In XL, indicating a positive number with a plus sign is just an extra
step, it serves no real function now.
 
Good to know! Thank you!!

David Biddulph said:
It does nothing. It means that the author of the formula has forgotten that
he is using Excel, and not an old Lotus spreadsheet.
Click to expand...
 
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

Formula problem 1
Formula problem 3
#value! 5
Formula problem 1
=IF((I4="R");H4;IF((H4>0);H4*E4;IF((I4=0);J4*E4;IF((J4>H4);J4*E4) 2
Returning last number(time) in a row of cells 4
What does { } mean in excel formulas? 4
Average last 3 entries 3

Back
Top