Formula updates when it shouldnt

[DropAGearN'Disappear]

Hello all,

I have a defined table that contains the following function. it is located in A2 and when I type in a cell anywhere on the table it updates the time. I only want the time to be added/updated when I enter into B2

=IF(B2="","",NOW())

[dosydos]

the NOW() function will update whenever the worksheet calculates or if it is in a macro and said macro is run.
1)So you can change your settings so that your workbook only calculates when you press a button.
2) Hardcode the value of the NOW() function
3) create a macro that will run the NOW()

[MrShorty]

If this is a timestamp sort of thing, you might review this tutorial: https://chandoo.org/wp/timestamps-excel-formula-help/

[DropAGearN'Disappear]

ANSWER! For future people who stumble past this

So if I want a timestamp put in cell A2 as something is entered into B2, Id place the following into cell A

=IF(B2<>"",IF(A2="",NOW(),A2),"")

we must first turn on iterative calculation mode by file >> option >> formulas >> check the box