SUM function opening new email

S

Sarah_Lecturer

Hi

I cannot understand why this happens
A
1 1
2 5
3 =@sum(A1:A2)

When I press Enter, a new email message opens, why?

Thanks
 
B

Bob Phillips

Because @ is not used in a formula in Excel. Just use

=SUM(A1:A2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
S

Sarah_Lecturer

What does @ do then? Why?

Bob Phillips said:
Because @ is not used in a formula in Excel. Just use

=SUM(A1:A2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
D

David Biddulph

Sarah_Lecturer said:
Hi

I cannot understand why this happens
A
1 1
2 5
3 =@sum(A1:A2)

When I press Enter, a new email message opens, why?
Click to expand...

It is presumably assuming that anything including an @ symbol is an e-mail
address. What does the @ mean in your context?
 
B

Bob Phillips

It doesn't do anything. I think you are thinking of old Lotus formulae. @ is
used to identify a domain name, such as in email addresses, which is why it
launches the mail function.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top