Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
what is the difference between this formula:
=+C31*$D$14 and this one: =C31*$D$14 both formula give the same results. what is the purpose of the plus sign? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
The plus sign serves no useful purpose whatsoever
It does tell us that maybe the originator of the workbook began life as a Lotus 123 users where formulas began with +. And that they have not yet found that Excel does not require them (old habits die hard - or not at all) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "KrispyData" wrote in message ... what is the difference between this formula: =+C31*$D$14 and this one: =C31*$D$14 both formula give the same results. what is the purpose of the plus sign? |
#3
![]() |
|||
|
|||
![]()
Hello!
Aside from the = sign, you can start a formula by using a + sign. While you can say that this is "useless", the main function of this is to just multiply the whole formula with +1, that's why it appears as if nothing happened. For the - sign, the inverse is true. It multiples the whole formula by -1, meaning a positive output of a formula becomes negative, and a negative output of a formula becomes positive. This can be useful in a number of applications. For more tips on excel and financial models, you can check this out. Hope this helps! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What does a plus sign in front of a cell reference mean? | New Users to Excel | |||
= sign in formula changes to + when adding a cell or name | Excel Discussion (Misc queries) | |||
How to put + sign in cell, not formula? | Excel Discussion (Misc queries) | |||
$ sign for absolute reference Explanation | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) |