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โ€ฆ

Solved Solved
0 2 198
1 ACCEPTED SOLUTION

Steve
Participant V

Try:

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

See also:

View solution in original post

2 REPLIES 2

Steve
Participant V

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

Top Labels in this Space