| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable in if statement
RC[-1] contains a formula which, in this row, produces the numeral 31
The next column contains this made up formula which produces what I want =IF(RC[-1]<"",Present!R[27]C5&" "&Present!R[27]C4,"") I should like to replace 'R[27]' with something like this but cannot make it work R[RC[-1]-4] How can I use what is in RC[-1] to bring the text from the Present page? Thanks you Francis Hookham |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement Variable | Excel Discussion (Misc queries) | |||
| How to pass a variable into an SQL statement | Excel Discussion (Misc queries) | |||
| if than statement has too many variable | New Users to Excel | |||
| testing more than one variable in an if statement | Excel Discussion (Misc queries) | |||
| Add 2nd variable to if statement - ifAnd? | Excel Worksheet Functions | |||
Threaded Mode
