| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to make IF function not change cell value?
How do I make a IF function do this? IF(CELL1 = X ,CELL1,CELL2) The formula
is located in CELL2. When the IF function is false, then I want the value in CELL2 to stay the same. I get a circular reference with this format. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the fill color of a cell using an "IF" function | Excel Worksheet Functions | |||
| Can you make a cell = 0 if original function is creating a"#ref!"? | Excel Worksheet Functions | |||
| function to change cell position and allows dragging | Excel Worksheet Functions | |||
| cell ref in function formula change when inserting additional colu | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
