Multiple Timestamps on worksheet

[comets1964]

My worksheet has multiple cells that load a timestamp NOW() based on a formula. When I change one of the cells and load the timestamp into a cell based on the formula, all timestamps change even though the other timestamps have different formulas referring to different cell values. I don't understand why this is happening.

 

[rollis13]

How about showing some of these formulas, we don't have a crystal ball.

 

[comets1964]

C6 value is 100.00
D6 formula is "=IF(C6<>C6,"",NOW())

C7 value is 200.00
D7 formula is "=IF(C7<>C7,"",NOW())

When C6 is changed to 150.00, D6 posts the correct timestamp as expected, however, D7 also changes to the same exact timestamp as if C7 was also changed.

 

[kevin9999]

NOW() is a Volatile function. It will recalculate whenever a change happens event anywhere on the sheet.