why do some use "=+" at the beginning of a formula?

R

RocketRod

I have found a few spreadshets from others where they start every formula
with a + sign immediately after the = sign.
e.g.
=+ROUNDUP(SUMPRODUCT(P25:DV25,P$21:DV$21),-1)
=+E26+G26+H26

Anyone know why they do it?
 
F

Fred Smith

It's a holdover from Lotus 1-2-3 days which started formulas with a + sign.

Using both = and + is superfluous. One of them can be deleted.

Regards,
Fred.
 

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

display zero values at the beginning of a number. 2
Formula to return the reference of a range of cells 4
How do I change the sign of a base number for use in XIRR? 1
Count Unique With one Condition & No ROUNDUP 7
Formula for counting number of blank cells in spreadsheet by row 1
Need help creating a formula 18
OK. I give. Why can't I use the "@" (at sign) in a text cell? 4
setting a formula that will sum at the end of data 1

Top