SUM formula returning negative currency values - w...

[ChaumeilDigital]

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

[Alessio_Monino · Accepted solution]

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

[ChaumeilDigital]

Thanks for your quick reply !