I have come across an accounting spreadsheet that uses the =+ operator multiple times, such as =+sum(A4:A28). I can't see what use the extra '+' is. Can anyone advise please?
Thanks very much.
I have come across an accounting spreadsheet that uses the =+ operator multiple times, such as =+sum(A4:A28). I can't see what use the extra '+' is. Can anyone advise please?
Thanks very much.
Totally redundant; absolutely no need for it. Don't worry about it, probably someone who doesn't know Excel particularly well.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Lazy people have been known to start a formula by hitting the + key instead of typing = since it's more accessible. This would produce the result you have, at least on older Excel.
I tried that just now on Excel 2010 and it seems that Excel removes the + sign so now there really is no reason not to start formulas with hitting + key.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
lotus123 used + to enter a value and it still gets used by some people
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
@Jacc: how is a + sign more accessible than an = sign ... you have to press shift and = to get +, at least on a UK English keyboard.
The + on a numeric keypad is pretty accessible, and large.+
If posting code please use code tags, see here.
It's an old habit for some people to start a formula with + instead of =, also a legacy of lotus123 and (shows age) supercalc - they both started any formula with +. It took me quite a while to break myself of that habit
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Whatever the history and habits, it's still redundant
Thanks very much for the insight. I had a feeling that it woudl be a user idiosyncracy, rather than an Excel form as i had never come across it before.
Thanks all.
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks