Overthinking nesting Formulas
I'm sure I am over thinking it, but I can't get these two to nest together to save some space...
=2 * 3
=IF(4 > 9.1, SUM(4 - 9), IF(4 < 9.1, 4))
Basically I want to multiply 2 rows together, then if it is greater than 9.1, I want it to subtract 9 and reflect that value, but if it is less than 9.1 I want it to reflect the original value of the multiplication.
Right now I have it in 2 separate rows, but I am trying to condense this sheet as much as possible to make it a little more use friendly.