Excel formulas for Dummies, please.
May 27, 2009 4:33 PM   Subscribe

This is probably a pretty basic Excel formula question, but I'm clueless.

I have a document with some numbers in a column, and there are 6 separate sheets with these numbers. I want to change the amount of each number to one quarter its current value (times 0.25). What is the formula for this? And how do I copy that formula from cell to the full column to all the columns in the remaining sheets?

If this is too vague, please let me know.
posted by zardoz to Computers & Internet (2 answers total)
 
Best answer: Assuming your numbers are in column A, put the following into cell B1
=A1*.25

Then, double click on the bottom right corner of cell B1 to autofill that formula down the column.
posted by willnot at 4:40 PM on May 27, 2009


Response by poster: Thanks willnot, easy indeed.
posted by zardoz at 5:09 PM on May 27, 2009


« Older Outlook 2003 runtime error '4198' - wuzzat?   |   Cheapest way to get a blackberry? Newer »
This thread is closed to new comments.