Today’s function is BEST_PIZZA_DEAL; it returns a summary of pizza value.
,LAMBDA(Pizza1_Size,Pizza1_Count,Pizza1_Price,Pizza2_Size,Pizza2_Count,Pizza2_Price=
LET(Pizza1Calc, Pizza1_Price / (PI() * (Pizza1_Size / 2) ^ 2 * Pizza1_Count),
Pizza2Calc, Pizza2_Price / (PI() * (Pizza2_Size / 2) ^ 2 * Pizza2_Count),
Variance, Pizza1Calc - Pizza2Calc,
Choice, IF(Variance <= 0, "Pizza 1", "Pizza 2"),
Result, HSTACK(
VSTACK(Choice & " is better value.", "", "Pizza 1", "Pizza 2", "Variance"),
VSTACK("", "Per SQ Inch", Pizza1Calc, Pizza2Calc, Variance)),
Result))
ليست هناك تعليقات:
إرسال تعليق