Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between + or = in entering a formula
Hello
I'm a long time MS Excel user and working with it on a daily basis, I find myself puzzled with it sometimes. For instance,... What is the difference when entering a formula with a + or an = sign? For me it's a single keystroke to enter it with the + sign. And when I do that sometimes it will just yield the result and overwrite the formula like so: +600/12 yields 50 both displayed in the cell and the cell's formula whereas =600/12 yields =600/12 as the cell's formula and 50 displayed in the cell. Any ideas? TIA Best regards L. PS: Prolly this is very newbie question to ask and prolly should RTF(ine)M. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between + or = in entering a formula
Lotus 123 liked formulas to start with some operand. Most people used +.
MS wanted to make it easy for people to dump Lotus 123 and use excel instead. So MS decided to make it easier for those people. I bet if you look at users who never used Lotus 123, they never/hardly ever use that +. They'll use =. Lencastre wrote: Hello I'm a long time MS Excel user and working with it on a daily basis, I find myself puzzled with it sometimes. For instance,... What is the difference when entering a formula with a + or an = sign? For me it's a single keystroke to enter it with the + sign. And when I do that sometimes it will just yield the result and overwrite the formula like so: +600/12 yields 50 both displayed in the cell and the cell's formula whereas =600/12 yields =600/12 as the cell's formula and 50 displayed in the cell. Any ideas? TIA Best regards L. PS: Prolly this is very newbie question to ask and prolly should RTF(ine)M. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between + or = in entering a formula
Funny thing is, I've never used Lotus 123, it is just one keystroke to
type + sign and Shift+0 to type = sign. It's that faster. Anything else? It is just weird to replace the formula for the result. L. On Mar 7, 7:00 pm, Dave Peterson wrote: Lotus 123 liked formulas to start with some operand. Most people used +. MS wanted to make it easy for people to dump Lotus 123 and use excel instead. So MS decided to make it easier for those people. I bet if you look at users who never used Lotus 123, they never/hardly ever use that +. They'll use =. Lencastre wrote: Hello I'm a long time MS Excel user and working with it on a daily basis, I find myself puzzled with it sometimes. For instance,... What is the difference when entering a formula with a + or an = sign? For me it's a single keystroke to enter it with the + sign. And when I do that sometimes it will just yield the result and overwrite the formula like so: +600/12 yields 50 both displayed in the cell and the cell's formula whereas =600/12 yields =600/12 as the cell's formula and 50 displayed in the cell. Any ideas? TIA Best regards L. PS: Prolly this is very newbie question to ask and prolly should RTF(ine)M. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between + or = in entering a formula
On my keyboard, there is a key just for the = sign. In fact, + is shift-=.
I don't understand the comment about replacing the formula for the result. Lencastre wrote: Funny thing is, I've never used Lotus 123, it is just one keystroke to type + sign and Shift+0 to type = sign. It's that faster. Anything else? It is just weird to replace the formula for the result. L. On Mar 7, 7:00 pm, Dave Peterson wrote: Lotus 123 liked formulas to start with some operand. Most people used +. MS wanted to make it easy for people to dump Lotus 123 and use excel instead. So MS decided to make it easier for those people. I bet if you look at users who never used Lotus 123, they never/hardly ever use that +. They'll use =. Lencastre wrote: Hello I'm a long time MS Excel user and working with it on a daily basis, I find myself puzzled with it sometimes. For instance,... What is the difference when entering a formula with a + or an = sign? For me it's a single keystroke to enter it with the + sign. And when I do that sometimes it will just yield the result and overwrite the formula like so: +600/12 yields 50 both displayed in the cell and the cell's formula whereas =600/12 yields =600/12 as the cell's formula and 50 displayed in the cell. Any ideas? TIA Best regards L. PS: Prolly this is very newbie question to ask and prolly should RTF(ine)M. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering numbers in a cel formula | Excel Discussion (Misc queries) | |||
Entering numbers in a cel formula | Excel Worksheet Functions | |||
Problems entering a formula | Excel Worksheet Functions | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
entering matrix formula | Excel Worksheet Functions |