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…