SUM function opening new email
 

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

SUM function opening new email
 

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)

"Sarah_Lecturer" wrote in message
...
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

SUM function opening new email
 

What does @ do then? Why?

"Bob Phillips" wrote:

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)

"Sarah_Lecturer" wrote in message
...
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

SUM function opening new email
 

"Sarah_Lecturer" wrote in message
...
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?

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

SUM function opening new email
 

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)

"Sarah_Lecturer" wrote in message
...
What does @ do then? Why?

"Bob Phillips" wrote:

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)

"Sarah_Lecturer" wrote in
message
...
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