Excel Issue with multiple conditions

Help Studio
#1

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

#2

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

#3

@gokavarapunaga.jagad

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

image
image662×511 11.4 KB

#4

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

Thanks in advance,
Jagadeesh