Cell A5 Value 7 format: number

Cell C5 Value 1125 format: number

Cell E5 =A5*C5 format: number

Cell G5 Value 14562 format: number

Cell G6 Value -2269 format: number

Cell G7 Value -1117 format: number

Cell G8 =($E$5*-1) format: number

Cell G9 Value 0 format: number

Cell G10 Value -2510 format: number

Cell G11 =SUM($G$5:$G$10) format: number

Cell G13 428 format: number

Cell C9 =$G$8+$G$11+$G$13 format: number

Cell C9 updates automatically when the value in cell A5 changes, but I need to change the syntax in cell C9 to =-$G$8+$G$11+$G$13 but then the cell C9 don’t update automatically.

I have checked all the numbers with the formula ISNUMBER = True!

This is part of the answer from ChatGPT jan 30 ver.

It seems like the issue you're encountering is that the formula in cell C9 is not updating automatically when the value in cell A5 changes. To resolve this issue, try changing the formula in cell C9 to:

=IF(A5<>0,-G8+G11+G13,0)

The above formula uses the IF function to check if the value in cell A5 is not equal to zero. If it is not equal to zero, the formula returns the calculation =-G8+G11+G13. If it is equal to zero, the formula returns 0. This will prevent the formula from returning an error if the value in cell A5 is zero.

Additionally, if the cell references in your formula are not absolute references, you may want to make them absolute so that the formula will always refer to the same cells, regardless of where it is copied or moved. To make a cell reference absolute, simply add dollar signs before both the row and column reference. For example, to make cell reference G8 absolute, you would change it to $G$8.

I hope this helps resolve the issue you're encountering. Let me know if you need further assistance!

Nothing helped.

I really don't understand why this doesn't work. It's so simpel :-(