| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to populate a cell where formula is NOT located
I'm using excel 2007.
I'm looking to have a logical test in one cell that will populate a different cell if true, or a third cell if false. For example, the logical test located in cell A1: If (A2=3, then Cell B2 = "True", then Cell B2="RED") Another variation is to have the value in a cell determine the new cell location. For example, IF(D1="","", then cell A(Row Number D1)="Populated") Solutions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Utilizing a Cell even with a Formula located inside it | Excel Worksheet Functions | |||
| Search in excel by date located in a cell | Excel Discussion (Misc queries) | |||
| function to populate different cell | Excel Worksheet Functions | |||
| How do I populate a worksheet name in a formula using a cell ref. | Excel Discussion (Misc queries) | |||
| How to populate column with formula based on value in cell | Excel Worksheet Functions | |||
Threaded Mode
