Help me with IFS formula

Please help me to correct my formula regarding this condition:

If the Weight Price is much higher than the Dimension Price, then the price shall be the Weight Price.
And if the Dimesion Price is much higher than the Weight Price, then the price shall be the Dimension Price.

The Formula is doesnt seem right, please help to correct:

(IFS(([WEIGHT PRICE] >= [DIMENSION PRICE]), [WEIGHT PRICE])). (IfS(([DIMENSION PRICE] >= [WEIGHT PRICE]), [DIMENSION]))

thank you so very much…

Try:

IFS(
  ([WEIGHT PRICE] >= [DIMENSION PRICE]),
    [WEIGHT PRICE],
  ([DIMENSION PRICE] >= [WEIGHT PRICE]),
    [DIMENSION]
)

See also:

Thank you so much for the information, it is working for the formula, appreciated it so much

1 Like