Question

queenzboulevard's avatar

Excel formula?

Asked by queenzboulevard (2449points) | asked November 17th, 2008 | 3 responses | “Great Question” (1points) | Flag as…

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

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…

tigran (679points)“Great Answer” (2points) Flag as…
johnpowell'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

johnpowell (21481points)“Great Answer” (2points) Flag as…
queenzboulevard's avatar

Yep both answers got the job done. ¡Gracias!

queenzboulevard (2449points)“Great Answer” (0points) Flag as…

Answer this question

Login

or

Join

to answer.
Your answer will be saved while you login or join.

Have a question about something? Ask Fluther!