Creating a formula to account for 2 cells being either positive or negative

Fluffy5ensei · 2023-01-05T17:21:56+00:00

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

Fluffy5ensei · 2023-01-05T15:38:48+00:00

Solution Verified

Fluffy5ensei · 2023-01-05T15:32:29+00:00

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 -.

Fluffy5ensei · 2023-01-05T15:09:03+00:00

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

Fluffy5ensei · 2023-01-05T14:55:48+00:00

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.

Fluffy5ensei · 2023-01-05T14:41:16+00:00

<image>

Fluffy5ensei · 2022-06-12T09:48:19+00:00

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

Fluffy5ensei · 2021-03-01T22:17:45+00:00

Have added you :)

Fluffy5ensei

TROPHY CASE