Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Global formula
How can I apply a formula to a range of cells without entering into each
cell. I have a spreadsheet with values and want to convert to another currency value. |
#2
|
|||
|
|||
No need for a formula although it is probably better using one, for instance
you can use a help column and put a formula like =A2*rate then just copy down or you can put the conversion rate in a cell, copy it, select the range and do editpaste special and select multiply Regards, Peo Sjoblom "George_Papas" wrote: How can I apply a formula to a range of cells without entering into each cell. I have a spreadsheet with values and want to convert to another currency value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Global formula | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |