How can I apply a basic calculation (f.ex. multiplied by 12) on variuous cells?
How can I apply a basic calculation (f.ex. multiplied by 12) on variuous cells?
HAve you tried copy, paste special, forumlas?
Create a formula referencing a cell with your constant (e.g. 12).
Example: in cell A1 place your constant (e.g.12)
Assuming your cells to apply this formula to are in column B1:B??, in C1 enter:
=B1*$A$1
copy this formula down col. C to the end of data in col. B
HTH
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks