How do i apply the same formula for different cells in excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tristan - 08 Jun 2007 05:41 GMT

i have these set of values in a column, how do i apply the same formula to
all of the values in the column? sorry please help.

Reply to this Message

Gary''s Student - 08 Jun 2007 10:21 GMT

Say we have numbers in column A from A1 thru A100. In column B we want the
value in column A divided by 5.

Select cells B1 thru B100 and enter:

=A1/5

Instead of using the ENTER key to complete the entry, use
CNTRL-ENTER

this will put the correct formula in all the B column cells.

Signature

Gary''s Student - gsnu200727

> i have these set of values in a column, how do i apply the same formula to
> all of the values in the column? sorry please help.

Reply to this Message