- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 22, 2023 06:07 AM
Hello,
I need to sum the two smallest values between three values.
Example:
- Value 1: 10
- Value 2: 20
- Value 3: 30
The two smallest values are "Value 1" and "Value 2".
How to do this via a formula (or other
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 22, 2023 09:42 AM - edited ‎Sep 22, 2023 09:56 AM
Hi @ChaumeilDigital,
This is a possible solution to create the calculation - you could create a formula that sums up all three values, then subtracts the largest value among the three using MAX() -> this gives us the sum of the two smallest values among the three (because it subtracts the largest)
I hope this helps!
Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 22, 2023 09:42 AM - edited ‎Sep 22, 2023 09:56 AM
Hi @ChaumeilDigital,
This is a possible solution to create the calculation - you could create a formula that sums up all three values, then subtracts the largest value among the three using MAX() -> this gives us the sum of the two smallest values among the three (because it subtracts the largest)
I hope this helps!
Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 22, 2023 10:23 AM
Thanks for your quick reply !
