Search for answers to your questions by entering keywords below, or look through our knowledge base.
Welcome to 'Sikkhon' User Forum
Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users.
You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.
Discount calculate less than and greater than | IF else
In our video PAD Design in Excel one of our students asked the below question.
1000. 2000. 3000. If the amount is greater than 1,000 then 10% discount and if less than 1,000 then 0% discount.
How to find the solution in Excel?
Solution:
we need to using IF and else to figure out easily a discount value and calculate their amount while applying all our conditions.
Let's check the examples:
Create a documnets like below. Amount and discount. i added some value in amount cell
Now, write the function in discount cell to get the value. and Press enter
=IF(B4>=1000,"10%","0%")
You will get 10% in reesult. because 1500 is greater than 1000
Now simply grad the values. Download attached excel file to see the example.
if you want to learn MS Excel Advance check the link Advanced Microsoft Excel Functions & Formulas
Attachments (1)
if-else.xlsx
8.98 KB
0 Votes
0 Comments
Login or Sign up to post a comment