Assistance needed with copying field to different places in Excel

[FLHawkI]

I have an Excel Spreadsheet with the following: Date contained in cell A2 and a drop down list in Cell E2. There are 3 possible selections in Cell E2 - Text1, Text2, Text3. If Text1 is selected I want the date in Cell A2 to be copied to Cell H4. If Cell E2 has Text2 selected the date in Cell A2 Copied to H5. If Cell E2has Text3 selected the date in Cell A2 to copy to Cell H6. I keep getting circular reference when I try to use an if statement. For example in cell h4 put IF(E2="Text1",A2, leave the date in the cell alone). Then in cell H5 I tried to put =IF(E2="Text2",A2,leave the date in the cell alone). Circular reference. I hope someone can help?

 

[FLHawkI]

Found it. Been programming for over 30 years so I knew it was possible. FILE --> OPTIONS --> FORMULAS then check Enable iterative calculation and set Maximum change to 1!

 

[FLHawkI]

Range	Formula
Cell Formulas
A2	A2	=TODAY()
H4	H4	=IF(E2="Text1",A2,"H4")
H5	H5	=IF(E2="Text2",A2,"H5")
H6	H6	=IF(E2="Text3",A2,"H6")

 

[FLHawkI]

Wasn't the A2 after all it was because I did not want the date to change if the Text field did not match.

 

[Alex Blakenburg]

There is nothing in the formulas @BigBeachBananas posted that should cause a circular error.
It seems likely your circular error is coming from a different cell.

FILE --> OPTIONS --> FORMULAS then check Enable iterative calculation and set Maximum change to 1!

I think changing this setting is a bad idea and that you are just masking the problem,
This is an application level setting and will impact any and all workbooks you are using.