Forum Discussion
DateStamp
Need help as to why the below formula will not function: =IF(R211<>"",IF(AND(Q211<>"",CELL("address")=ADDRESS(ROW(R211),COLUMN(R211))),NOW(),IF(CELL("address")<>ADDRESS(ROW(R211),COLUMN(R211)),Q2...
Giron87 it works for me, though I did notice one part of your formula will never evaluate to TRUE:
CELL("address")=ADDRESS(ROW(R211),COLUMN(R211))
Since you refer to R211 in your formula, I'm assuming the formula resides in another cell. Therefore the address containing the formula will never match the address for R211. As a result, if R211 = "" the formula always returns "", the very last part of your formula.
What's not working for you? Can you provide a sample if this isn't the issue?
Dexter