the cell in question is formatted as 'general' (also had it formatted as a 'number'... but nothing changed with it formatted that way, or any other different way for that matter...)

when formula is calculating CORRECTLY, it should populate the cell in the column that corresponds with the source cell (J2) with a "1" (otherwise the cell is supposed to remain blank.)
(in the example below, the number in the source cell, '143', should prompt a "1" appearing in column U, which contains the formula: =IF(AND($J2>=121,$J2<= 150), "1", "")

but that formula ONLY works if I manually double click in the source cell (in column J) and then hit 'enter':
(below it shows where the formula in AX7, which is: =IF($J7>7300, "1", "") is incorrectly showing a "1" (as do all of them in that column
)

but after hitting the enter key in the cell with the number 94 (J7), it correctly populates cell T7 (which contains the formula =IF(AND($J7>=91,$J7<= 120), "1", "") ) and also correctly leaves blank AX7 (which it should be)

so far I've tried:
saving, closing and reopening the workbook, turning off and then back on the enable calculations.... and (after finding a possible solution after googling this), manually doing a search and then find and replacing "=" with "=" (equal sign with equal sign) (which surprisingly worked for a number of people who encounter this problem, but not with me! lol)
any ideas on what is doing this? Thanks

when formula is calculating CORRECTLY, it should populate the cell in the column that corresponds with the source cell (J2) with a "1" (otherwise the cell is supposed to remain blank.)
(in the example below, the number in the source cell, '143', should prompt a "1" appearing in column U, which contains the formula: =IF(AND($J2>=121,$J2<= 150), "1", "")

but that formula ONLY works if I manually double click in the source cell (in column J) and then hit 'enter':
(below it shows where the formula in AX7, which is: =IF($J7>7300, "1", "") is incorrectly showing a "1" (as do all of them in that column


but after hitting the enter key in the cell with the number 94 (J7), it correctly populates cell T7 (which contains the formula =IF(AND($J7>=91,$J7<= 120), "1", "") ) and also correctly leaves blank AX7 (which it should be)

so far I've tried:
saving, closing and reopening the workbook, turning off and then back on the enable calculations.... and (after finding a possible solution after googling this), manually doing a search and then find and replacing "=" with "=" (equal sign with equal sign) (which surprisingly worked for a number of people who encounter this problem, but not with me! lol)
any ideas on what is doing this? Thanks