create a function for Discount if qty > 50 then take 5% off total

  • Thread starter Thread starter Guest
  • Start date Start date
Use the If function that as three parts, test condition, what to do if
condition is true, and what to do if conditions is false. If Qty is in cell
A1 and Price is in B1 the formula would look like =IF(A1>50,5%*B1,0).

The test condition is if A1 is greater than 50. Be careful. This will not
include 50. If you want to include the value 50 change it to >= (greater
than or egual to); the do if true multiplies PRICE in B1 by 5%; and the do if
false part returns the value of zero.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup 2 fields 3
Creating drop downs for part number configuration 2
if questions 4
vlookup 2 fields 2
Formula to lookup item for Qty? 2
IF function OK to use? 1
IF and Vlookup 1
Max Price and Min Price paid for an item - Rephrsed 4

Back
Top