Addition of values in excel with conditions

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)

any thoughts :thinking:

Hi @Sonia_012 ,

One simple solution would be like this:

Here is the test file: SwirchCase.xaml (12.8 KB)

Hope this helps
Best regards,
Marius

Hi Marius,
Thank you however i need to total the amount first and then put the condition.
E.G. - for ABC 100+100 =200 so the condition will should appear for 200.
sorry if i had not explained properly. let me know if any queries.

Hi @Sonia_012
Check this workflow
sample workflow.zip (2.0 MB)

Mark it as solution if it resolves your query

Regards
Nived N
Happy Automation

1 Like

@Sonia_012
have a look below as it is similiar to your case. It is implementing a mapping function for numbers to segments:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.