In Google Sheet, cell I46 contains this formula:
= iferror(average(C46:H46), "")
And cell J46 contains this formula:

=IF(len(I46) = 0, "",
    IF(I46 >= 4.8, 150000,
       IF(AND(I46 >= 4.5, I46 < 4.8), 100000,
          IF(AND(I46 >= 4.2, I46 < 4.5), 0,
             IF(AND(I46 >= 3.9, I46 < 4.2), -100000,
                IF(I46 < 3.9, -150000, "")
             )
          )
       )
    )
 )

(this is what I got from asking chatGPT)
problem: cell I46 has the value 4.8, which should prompt 150000 in cell J46, but 100000 is showing instead -> Can anyone help me?

for context: I set the locale in the US, so the decimal separator is dot (“.”). Also, I do not think there’s something wrong with the format, as the same function works perfectly fine for other rows

Tried asking chatGPT, but can’t give me the answer I’m looking for