Forum Discussion
IF cell A1=A, after 15 minutes, automatically change into B
I need a formula to change value from A to B after 15 minutes of inserting A. The ChatGPT suggested me this formula but it did not work =IF(A1="A",IF(NOW()>=A1+TIME(0,15,0),"B",A1),"")
Thank you anyway, but in Google Sheets, we do not have VBA (instead is AppScript) but I cannot find a way to follow from step 5 so on
Google Sheets, unfortunately I can't help there, my knowledge is limited.
If I may recommend, always include accurate information about your digital environment at the beginning. digitsle environment such as Excel version, operating system, storage medium, etc. This would help you to get faster and more accurate solution suggestion and on the other hand would save much time which will benefit other users.
Thank you for your understanding
If I may recommend, always include accurate information about your digital environment at the beginning. digitsle environment such as Excel version, operating system, storage medium, etc. This would help you to get faster and more accurate solution suggestion and on the other hand would save much time which will benefit other users.
Thank you for your understanding