Excel formulas for Dummies, please.

May 27, 2009 4:33 PM

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 (3 comments total)

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

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

Continuing on willnot's thought... if you then want to replace the old numbers with the new calculated value, select the calculated value column, Edit > Copy, select the original column, choose Edit > Paste Special and check the Values box.
posted by odinsdream at 5:09 PM on May 27