Sep 12 2022 08:23 AM
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)),Q211,NOW())),"")
Sep 12 2022 10:58 AM
@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