help on a Formula

[Guest]

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

 

[Sue Mosher [MVP-Outlook]]

DId you mean to post this in an Excel group?

 

[Guest]

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

 

[Gordon]

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......

 

[Guest]

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

 

[Guest]

or turn it around as :

=sum(a1:a3)*1.2

both will work