Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I make a formula in Excel to display result in same cell?
I am trying to make a cell in which the formula and the entry field are in
the same cell... In other words getting a formula to be locked in a cell to where whatever info I put in the cell, the locked formula calculates the entry number. |
#2
|
|||
|
|||
Not without using the f2 key to edit or a worksheet_change macro.
-- Don Guillett SalesAid Software "Neiko" wrote in message ... I am trying to make a cell in which the formula and the entry field are in the same cell... In other words getting a formula to be locked in a cell to where whatever info I put in the cell, the locked formula calculates the entry number. |
#3
|
|||
|
|||
Hi!
Maybe this might help: http://tinyurl.com/bcakp Biff "Neiko" wrote in message ... I am trying to make a cell in which the formula and the entry field are in the same cell... In other words getting a formula to be locked in a cell to where whatever info I put in the cell, the locked formula calculates the entry number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Display excel formula on worksheet | Excel Worksheet Functions |