S Banerjee
New Member
I have to calculate percentage in a cell B1, on the basis of value A1 as per following:
If A1 cell value is below 1000 then, B1=0% of A1;
If A1 cell value is 1001 to 5000 then, B1=10% of A1;
If A1 cell value is 5001 to 10000 then, B1=20% of A1;
If A1 cell value is above 10000 then, B1=30% of A1;
Please help me.
If A1 cell value is below 1000 then, B1=0% of A1;
If A1 cell value is 1001 to 5000 then, B1=10% of A1;
If A1 cell value is 5001 to 10000 then, B1=20% of A1;
If A1 cell value is above 10000 then, B1=30% of A1;
Please help me.