"+" in front of a formula

Kintantay

Board Regular
Joined
Nov 4, 2002
Messages
80
While viewing the MrExcel tip card, the section for relative and absolute references displays the following formula:

=+B5*(1+$B$2).

If the card is not accessible, $B$2 has a %, 4.1 to be exact. B5 has a price of 1.76. the formula is in cell C5.

My question is why the "+" after the equal sign. If I remove the "+" the result are the same. I have come across this on a few spreadsheet and never could understand the relevance.. Please explain...

Thanks in advance!
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

ExcelChampion

Well-known Member
Joined
Aug 12, 2005
Messages
976
I've heard that since the keypad does not have an equal sign, that the + will work as an equal sign and Excel upon confirmation Excel inserts the equal sign.
 

Craig92604

Well-known Member
Joined
Nov 7, 2002
Messages
505
The Champion is correct. When ever I enter data and formulas I use the 10 keypad and the + sign is the easieast to use and does represent =.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,723
Members
410,630
Latest member
JFORTH97
Top