• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to insert formula for between numbers n to n

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.
 
thank you guys. i will put some more qs because this forum is highly responsive. i am learning excel. Thank you N & S :DD:DD
 
Back
Top