| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function
Hi,
I have the formula in A2: =OFFSET(A2,-1,0)*12.36% This multiplies A1 by 12.36. How do I change this formula so that it can be input into any cell, and always multiply the cell above it by 12.36%? In other words, when using the OFFSET function, how do I make the Reference argument equal the cell that the formula is in? Thanks in advance, Dave. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
| Use of OFFSET function | Excel Worksheet Functions | |||
| Offset Function | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| offset function | Excel Worksheet Functions | |||
Threaded Mode
