What does a plus sign in front of a cell reference mean?

K

KrispyData

how is the following formula:

=+C31*$D$14

different from

=C31*$D$14?

what is the significance of the plus sign when the results are the same?

thanks!
 
D

Dave Peterson

Some people learned about spreadsheets using Lotus 123. Those people used the +
to indicate a formula. And they want to continue using it. It's not necessary.
 

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

plus sign before cell reference in formula 1
IF statement on a range of cells in Excel 2007 4
SUMPRODUCT ---> semicolon (;) vs. plus sign (+) 5
significance of $ sign in a excel formulea 2
How to, number of entries 2
Referenced cell displays formula, not data 4
Sumproduct where cell values are the same in a sorted column 1
View lengthy text from one cell to another cell without widening c 1

Top