Excel Issue with multiple conditions

Hi All,

To Check the Credit Flag. If it is N, then , check the customer Class{if High than ((Amt 1+Amt 2+Amt 3+Amt 4+Amt 5) + Amt Spend <= Amount Allotted + 10% of Amount Allotted) than the customer is allowed to spend more otherwise put that customer on HOLD}, {if MED than ((Amt 1+Amt 2+Amt 3+Amt 4+Amt 5) + Amt Spend <= Amount Allotted + 15% of Amount Allotted),than the customer is allowed to spend more otherwise put that customer on HOLD} and {if LOW than ((Amt 1+Amt 2+Amt 3+Amt 4+Amt 5) + Amt Spend <= Amount Allotted + 20% of Amount Allotted),than the customer is allowed to spend more otherwise put that customer on HOLD}. At last log all these customer info in a log sheet with all the calculation data as well. Can Anyone help me on this?

Thanks in advance,
Jagadeesh

@Pravin_Patil1 Seen your previous solutions. Can you help me on this?

@gokavarapunaga.jagad

Instead of using nested if go with flowchart…and use decisions to go to the required sequence…

But we have to do by taking the data from excel. Can You help me on that?

Thanks in advance,
Jagadeesh