View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lencastre Lencastre is offline
external usenet poster
 
Posts: 2
Default 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.