Help with Formulas

S

Shanny

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
 
S

Sean Timmons

OK, this will work 2 ways. You're looking for =sum(a1:a3)+sum(a1:a3)*.20

but, much easier as: =sum(a1:a3)*1.2. :)

hth
 
P

PCLIVE

As you can see, there are many ways to achieve the same result.
To support your original attempt method:

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

Regards,
Paul
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Formula fill series? 1
help on a Formula 5
Newbie Help - IF Yes No Function 0
Looking to added up based on a character from cell range 1
VBA Coding Help for Beginner 0
Request Form - Alert Team Member 0
Combining Text From Cells 3

Top