In one cell..................

=SUM(A1:A3)*1.2

Or if the 20% is variable and entered in B1...............

=SUM(A1:A3)+SUM(A1:A3)*B1


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 08:32:05 -0700, 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