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]2 * [2]3
=IF([2]4 > 9.1, SUM([2]4 - 9), IF([2]4 < 9.1, [2]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.
Comments
-
Hi there, this should do the trick for you. IF your calculation is > 9 then it will perform the calculation and subtract 9, if not, then it will just perform the calculation.
=IF([2]2 * [2]3 > 9, [2]2 * [2]3 - 9,Β [2]2 * [2]3)
Β
-
-
No problem! Glad I could help!Β
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives