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.
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.
This thread is closed to new comments.
=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