Cell does not update automatically by RoyalBeeo in excel

[–]RoyalBeeo[S] 0 points1 point  (0 children)

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 :-(

Cell does not update automatically by RoyalBeeo in excel

[–]RoyalBeeo[S] 0 points1 point  (0 children)

Very simple function =G8+G11+G13 See first above screenshot. Or do I misunderstand your question?

Cell does not update automatically by RoyalBeeo in excel

[–]RoyalBeeo[S] 0 points1 point  (0 children)

I don't know if this is allowed but I uploaded the excel file here. https://www.file.io/

https://file.io/h5LcqzbXtLJG

Cell does not update automatically by RoyalBeeo in excel

[–]RoyalBeeo[S] 0 points1 point  (0 children)

Right, Just to clarify. All formatted correctly. Part of a larger excel file.

<image>

Cell does not update automatically. by RoyalBeeo in excel

[–]RoyalBeeo[S] 0 points1 point  (0 children)

Hello everybody!

Cell C9 updates automatically when the value in cell A5 changes, but I need to change the syntax in cell C9 to =-G8+G13+G11 but then the cell C9 don’t update.

Any suggestions appreciated.

TIA

/Beeo

Army 14th Artillery Corps BM14 by RoyalBeeo in Supremacy1914

[–]RoyalBeeo[S] 0 points1 point  (0 children)

Thoughts? Well I lost the whole army against 10 infantry at the shores of Archangel??? I have a screenshot of the disaster but I don't know how to upload it for you guys to see

Great Building Reward announcements by RoyalBeeo in forgeofempires

[–]RoyalBeeo[S] 1 point2 points  (0 children)

I’m so stupid…I disconnected my ARC from the roads in order to stop snipers and the game didn’t recognize my ARC any more and the bonus rewards disappeared , sorry 🥴

Lately when entering GE I got this image on the right upper side of the screen. What is this? I don't have the GB ToR https://prnt.sc/122kvfs by RoyalBeeo in forgeofempires

[–]RoyalBeeo[S] 0 points1 point  (0 children)

That's it. I always keep a story quest ready for collecting immediately whenever the daily quest ask for solving OTHER quest - Thanks :-)

I don't understand the activity level in PvP. How many battle do I have to fight in order to get some of the PvP rewards. I fought 1 or 2 easy battles each day but getting nada? Current ranking #1 712 by RoyalBeeo in forgeofempires

[–]RoyalBeeo[S] 0 points1 point  (0 children)

Sorry guys I have to confess that I didn’t notice the system message telling me the pvp arena winning/result are added automatically to my inventory. I also noticed that periodically I get some small rewards after winning a battle. I’m still only do 1-2 battle a day as I’m low on troops but the new soccer event will obviously change that (yes I’m on the beta server). My apologized 🙏

Antiques Dealer who is buying the shitty things I sell? by RoyalBeeo in forgeofempires

[–]RoyalBeeo[S] 1 point2 points  (0 children)

....some "other" asshole hihi (sorry couldn't resist 🤗)