Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I am new to excel and I am trying to learn how to hide formulas once I have the data entered into a cell. Here is my question if for instance lets say that in column c i have data entered from 2 to 100 and then say something changes and I have to add or subtract 10 from each of those cells. Before what I was doing in a blank column off to the side I would simply use this =c2+10 and then copy down to the end and then cut and paste those results in the original column. I don't mind doing that if when i cut and paste the fomulas aren't pasted with the number. I just want the cell to be a number by itself. THank you and I hope this makes sense. zmr325 p.s. does anybody have easy formulas for a weighted moving average and an exponential moving average. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |