| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing the function in the active cell
I have a spreadsheet with column C that is a calculation (=A1+B1). As long
as i have data in columns A and B, there is a value in column C. When I put activate an empty cell in column C (i.e. shares a row with no data in columns A and B), the formula (=An + Bn) does not show up in the command line. But when I enter data in this row (in columns A and B), then column C automatically applies the formula. Why is this? I would expect to see the formula (=An + Bn) in the active cell if a formula is going to apply. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing Lists in active cell | Excel Discussion (Misc queries) | |||
| using the active cell as a reference in a function | Excel Worksheet Functions | |||
| active cell address with worksheet function | Excel Worksheet Functions | |||
| referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
| Load active cell data via a function | Excel Worksheet Functions | |||
Threaded Mode
