Question: I have a password lock in my app. The user can save a password in the settings, and choose to only allow a user into the application with a password. When the app starts, the user is presented with a splash screen. In this Activity, if the user has chosen to enable password lock in the settings, I present a dialog that asks for the password.

To make sure that the user who wants the app locked is presented with this screen every time they try to use the app, I have set:

```
android:clearTaskOnLaunch="true"

```

in the Manifest for this Activity, which is the launch/main activity of my app. What sucks about this is that it does not let other users multitask (users who haven't chosen to lock the app) away, and come back where they left off. IF and only if they have come into the app through this activity. If, however, they come into the app through a different Activity (I have a widget that broadcasts a few different Intents), then the user can multitask, and come back into the app where they left off (until they actually back all the way out of the app using the back button).

Is there a way to get both sets of functionality here? Can I have the app always open to the password lock splash screen for users who want password lock, and have good ol' multitasking without messing with how the app loads for the other users?

Answer: 
You are looking for the `INDIRECT` [function](http://support.microsoft.com/kb/151323)

```
 =INDIRECT("C"&(24-A1))

```
You can do this with the OFFSET [function](http://office.microsoft.com/en-us/excel-help/offset-HP005209208.aspx)

=OFFSET(C24,-A1,0)

This will take the location of cell C24, subtract A1 from the row reference, and add 0 to the column reference.