| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enter data into a cell that already has a function.
Cell B4's value is predicated on the value of cell A4. If cell A4 has a
particular value, I need to be able to type data into cell B4. A4 = "Dodge" then B4="1" A4="Ford" then B4="2" A4="Chevy" then B4="3" but is A4="Pickup" then B4= data to be typed in Is there a way to keep the function and still be able to type data into cell B4? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
| Enter data and display function result in same cell | Excel Discussion (Misc queries) | |||
| how do I remove fx from the function line, can't enter data | New Users to Excel | |||
Threaded Mode
