"+" in front of a formula

[Kintantay]

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!

 

[Oaktree]

I'm not familiar with the tip card, but see http://www.mrexcel.com/board2/viewtopic.php?t=232140 for a brief discussion about why you might occassionally see =+ in an Excel formula.

 

[ExcelChampion]

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.

 

[Kintantay]

Thank for the reference Oaktree.

 

[Craig92604]

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 =.