If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Help:

chernobyl · 2002-05-20 00:05:10

I have a spread sheet with 8 figures accross and i want to add these 8 numbers and produce the answer and then in the next cell i want to add 21% to that answer. I want to repeat this for all cells below that, which i highlight. Thanks.

20-05-2002 1:05am

#1

chernobyl

Closed Accounts Posts: 2,682 ✭✭✭

Join Date: April 2001

Posts: 2519

I have a spread sheet with 8 figures accross and i want to add these 8 numbers and produce the answer and then in the next cell i want to add 21% to that answer.

I want to repeat this for all cells below that, which i highlight.

Thanks.

0

Comments

#2 20-05-2002 1:29am

sceptre

Registered Users, Registered Users 2 Posts: 19,608 ✭✭✭✭

Join Date: May 2001

Posts: 17984

Just ctrl-C the cell where you add the 21%. Highlight the cells where you want to duplicate the formula and paste
(after putting your (cell)*1.21 in of course)

(maybe I'm missing something, don't think so though)

0
#3 21-05-2002 5:33pm

tmcd

Registered Users Posts: 125 ✭✭

Join Date: March 2001

Posts: 90

Lets say the first figure is in cell a1 and the second figure is in b1 then c1 d1 and so on
Well then the formula you want is =SUM(A1:H1)*121%

0
#4 21-05-2002 5:37pm

tmcd

Registered Users Posts: 125 ✭✭

Join Date: March 2001

Posts: 90

oh yeah stick that formula into the I1 cell

0