General Question

queenzboulevard's avatar

Excel formula?

Asked by queenzboulevard (2551points) November 17th, 2008

I want C2 thru C32 to subtract 15 from the amount in B2 thru B32, and obviously I don’t want to type B2–15, B3–15, B4–15 etc. in each C cell, so what can I type in order to accomplish this in one formula?

Observing members: 0 Composing members: 0

3 Answers

tigran's avatar

you double click on C2. Once inside, write the following:

=B2–15 (instead of writing B2, you could also click on the actual cell B2)

Then click Enter

Then move the mouse over the lower right corner of C2, and once it turns into a +, use it to drag the box until C32

hope that made sense…

jrpowell's avatar

This might help.

Fill out the formula for C2 and click on that and drag down to select all the cells you want that formula to apply to. Then Edit—> Fill—> Down

queenzboulevard's avatar

Yep both answers got the job done. ¡Gracias!

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther