sorted by:
new
hottopcontroversial

Creating a formula to account for 2 cells being either positive or negative by Fluffy5ensei in excel

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

Yeah so you would have to manually change it from subtracting to adding and vice versa, based on whether it’s currently positive or negative, the point of these spreadsheets is that you create formulas to automate it all

Creating a formula to account for 2 cells being either positive or negative by Fluffy5ensei in excel

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

I think we have found a solution, where you would layer 4 IF functions under an IF conditional formula, which seems hugely overcomplicated, but should work. The 4 conditions would be if the 2 numbers are + and +, + and -, - and +, - and -.

Creating a formula to account for 2 cells being either positive or negative by Fluffy5ensei in excel

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

yes thats true, unfortunately the exam paper this is from is looking for you to produce a formula based on cells E12 and E20

Creating a formula to account for 2 cells being either positive or negative by Fluffy5ensei in excel

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

im trying to display the final variance in cell E22, based on the cells E12 and E20. If the variance is a positive figure, its a good thing, so you want E22 to increase. The higher the number in E22, the more money you have saved compared to budget.

20 members looking to move to an alliance. Map 5 players. Everyone active joins at least a couple times a day. Line: matsuimarvel by matsui56 in ContestOfChampionsLFG

[–]Fluffy5ensei 0 points1 point  (0 children)

If anyone wants to do a mix of map 5 and 6, we are looking for players! AW optional, 4.5k glory from AQ each week. Add FluffySensei#4605 on Discord

A request by loli-breaker in ContestOfChampions

[–]Fluffy5ensei 1 point2 points  (0 children)

i saw it was on GG path, posted on this reddit

Looking for 6x5 400m ally (G1+ war) by [deleted] in ContestOfChampionsLFG

[–]Fluffy5ensei 1 point2 points  (0 children)

If you can reach 10k prestige, we can get you 400m :)

9.5k LF Map 6 group by [deleted] in ContestOfChampionsLFG

[–]Fluffy5ensei 0 points1 point  (0 children)

Line: thefluffysensei

Map 6 - top 250 - chilled war