help on a Formula
 

I have a colleague that asked help with a formula - He would like to add 3
cells up and then multiply it by 20% and add that into the total

I tried =sum(a1:a3)+(a1:a3*.20)
but it didn't work

Can this be done in one cell or do you have to use two cells to calculate
this.

thanks
Shanny

help on a Formula
 

DId you mean to post this in an Excel group?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Shanny" wrote in message ...
I have a colleague that asked help with a formula - He would like to add 3
cells up and then multiply it by 20% and add that into the total

I tried =sum(a1:a3)+(a1:a3*.20)
but it didn't work

Can this be done in one cell or do you have to use two cells to calculate
this.

thanks
Shanny

help on a Formula
 

Yes I did - I thought I was in Excel - I am so sorry - Do I repost it?

"Sue Mosher [MVP-Outlook]" wrote:

DId you mean to post this in an Excel group?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Shanny" wrote in message ...
I have a colleague that asked help with a formula - He would like to add 3
cells up and then multiply it by 20% and add that into the total

I tried =sum(a1:a3)+(a1:a3*.20)
but it didn't work

Can this be done in one cell or do you have to use two cells to calculate
this.

thanks
Shanny

help on a Formula
 

"Shanny" wrote in message
...
Yes I did - I thought I was in Excel - I am so sorry - Do I repost it?


Umm yes, as this is for Outlook Contacts, which doesn't use formulae......

help on a Formula
 

U can do this way.... =120%*(sum(a1:a3))

"Shanny" wrote:

I have a colleague that asked help with a formula - He would like to add 3
cells up and then multiply it by 20% and add that into the total

I tried =sum(a1:a3)+(a1:a3*.20)
but it didn't work

Can this be done in one cell or do you have to use two cells to calculate
this.

thanks
Shanny

help on a Formula
 

or turn it around as :

=sum(a1:a3)*1.2

both will work
--
smither fan


"legend query" wrote:

U can do this way.... =120%*(sum(a1:a3))

"Shanny" wrote:

I have a colleague that asked help with a formula - He would like to add 3
cells up and then multiply it by 20% and add that into the total

I tried =sum(a1:a3)+(a1:a3*.20)
but it didn't work

Can this be done in one cell or do you have to use two cells to calculate
this.

thanks
Shanny