| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Calculations
Hello: I would like to select a row of numbers, then perform the same calculation on each value in each cell with the result replacing the old value in each cell. For example, I have values in cells C5:C21. I would like to take each individual value and perform the same calculation, =power(cell value - 6) with the new result replacing the old value in each cell. Thanks for any help! -- jzimm ------------------------------------------------------------------------ jzimm's Profile: http://www.excelforum.com/member.php...o&userid=32299 View this thread: http://www.excelforum.com/showthread...hreadid=520551 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
