| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
want to apply function to numerous cells
HI,
Basically I want to divide a number of cells by a number in another cell. So say, A1 through A10 by C3. However, I do not want to make the change permanent, and I want to be able to see what the values would be if C3 changes. So apart from manually going thru and adding the = and /C3 is there a way to map that = xC3 to the original cells. (I know its a circular reference of sorts, but can i write a macro to perform that task for me.. or is there some other way?) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to find which cells add up to a given total? | Excel Worksheet Functions | |||
| Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Date & Time | New Users to Excel | |||
| How secure is the "lock cells" function? | Excel Worksheet Functions | |||
Threaded Mode
