ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What does is mean when I see a "+" beginning a formula (https://www.excelbanter.com/excel-discussion-misc-queries/225616-what-does-mean-when-i-see-beginning-formula.html)

cefwork

What does is mean when I see a "+" beginning a formula
 
What does is mean when I see a "+" beginning a formula. =+j2-g4/(h4). What
does the "+" do?

David Biddulph[_2_]

What does is mean when I see a "+" beginning a formula
 
It does nothing. It means that the author of the formula has forgotten that
he is using Excel, and not an old Lotus spreadsheet.
--
David Biddulph

"cefwork" wrote in message
...
What does is mean when I see a "+" beginning a formula. =+j2-g4/(h4).
What
does the "+" do?




Luke M

What does is mean when I see a "+" beginning a formula
 
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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"cefwork" wrote:

What does is mean when I see a "+" beginning a formula. =+j2-g4/(h4). What
does the "+" do?


cefwork

What does is mean when I see a "+" beginning a formula
 
Good to know! Thank you!!

"David Biddulph" wrote:

It does nothing. It means that the author of the formula has forgotten that
he is using Excel, and not an old Lotus spreadsheet.
--
David Biddulph

"cefwork" wrote in message
...
What does is mean when I see a "+" beginning a formula. =+j2-g4/(h4).
What
does the "+" do?






All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com