Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Sum the two smallest values between three values

Topic Labels: Formulas
Solved
Jump to Solution
979 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ChaumeilDigital
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Alessio_Monino
9 - Sun
9 - Sun

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

See Solution in Thread

2 Replies 2
Alessio_Monino
9 - Sun
9 - Sun

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

Thanks for your quick reply !