Dear Master,
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 | |
120 | >(Greater than) | bad |
please assist
Work.xlsx (13.4 KB)