Help

Sum the two smallest values between three values

Topic Labels: Formulas
Solved
Jump to Solution
870 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 !