Formula Help

Copper Contributor

I have created a general formula (=F6*G6) and then copied all they way down my column (1312 lines)

every row no matter what the value is in F or G is showing the same total in each of the result cells.

 

For example

Column FColumn GResults
12600.245$308.70
21370.00701$308.70
30000.00701$308.70
98630.00701$308.70
50000.085$308.70
40000.047$308.70
25000.01095$308.70
30000.2205$308.70
4390.2205$308.70
50000.0036$308.70
150000.0036$308.70

 

Might something have been turned off in my setting that isn't auto updating the results for each of these cells? The only way I can get it to update right now is to F2 each cell that I want it to update.

1 Reply

@EWillis 

Check in Formulas section of the ribbon what you are not in manual calculation mode

image.png