| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thank you very much!!
"RagDyeR" wrote: Enter 75 in say Y1 (out of the way area). Say names in Column A, A2:A50 Points in Column B, B2:B50 Enter this formula in C2: =(B2<"")*$Y$1*B2 And copy down as needed. Where you can simply change the value in Y1, which will automatically change *all* the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Victoria" wrote in message ... Hi I would be very grateful for help in the following: I am creating a spreadsheet which I want to update on a weekly basis. I would like to be able to make a point have a value i.e. 1 point = £75.00 I would like to reference the cell so that when I enter increased points in one cell it will show the value in pounds in another cell and update whenever there is a change. I am sure that I have done this before (absolute referencing with interest rates??) Can anyone point me in the right direction? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing Sheets in a Formula | Excel Discussion (Misc queries) | |||
| formula referencing another workbook | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
| Creating a formula that references other sheets | Excel Worksheet Functions | |||
Threaded Mode
