| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula reading formula instead of cell content
Column I has this formula: =IF(AND(H173K173,AH173<0),"Past TAT","")
Column H also has a formula that sums days. =IF(OR(Y173<"",W173=""),"",TODAY()-W173) Column H is working and producing no days as required. However, the formula in column I seems to be seeing the formula in column H instead of the blank cell and keeps giving me a "Past TAT." When I delete the cell formula from column H, the "Past TAT" disappears from column I. Maybe instead of a blank cell it should have a zero when the conditions are met. Help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
| Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
| IF/AND Formula seems to only be reading 1st part of formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Threaded Mode
