| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula for displaying the cell reference of the selected cell
I have drawn a keyboard in excel (B1 is note C, C2 is note D etc). The user
is told to click on the note E. I then have an If statement that says if cell A2 displays D1 (ie note E) then to say 'well done that is correct' and if not then display 'wrong have another go'. My problem is getting a formula in A2 which displays what has been selected, so the If statement can work! Emma -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200603/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Display the cell reference of the cell that is currently selected. | Excel Worksheet Functions | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
Threaded Mode
