DateStamp

Copper Contributor

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

1 Reply

@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