i have below query.
i am trying to total the amount mentioned in Sheet1 and out the value based on the condition mentioned in Sheet2
|IF TOTAL PRICE is|
|Value||Condition||then Print in Total Price|
|60||<=(Less than or equal to||GOOD|
|61-120||>=(greater than or equal to||Fair|
Work.xlsx (13.4 KB)