Forum Discussion

Giron87's avatar
Giron87
Copper Contributor
Sep 12, 2022

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)),Q211,NOW())),"")

office 365
  • DexterG_III's avatar
    DexterG_III
    Iron Contributor
    Sep 12, 2022

    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

Resources