| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can an If statement return a formula for false?
Help...
=IF(I3="Closed","Closed",D3-$D$1) Column I = Open or Closed D1 = =TODAY() The rest of column D = =DATE(YEAR(C3),MONTH(C3)+6,DAY(C3)) Can you return a formula in an IF statement as i get a circular ref Thanks Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested If Statement "FALSE" Return | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| I have an IF formula to return column heading for FALSE | Excel Discussion (Misc queries) | |||
| IF formula to return column heading for False logic | Excel Discussion (Misc queries) | |||
| Easy formula to return a true or false | Excel Worksheet Functions | |||
Threaded Mode
