Home |
Search |
Today's Posts |
#1
|
|||
|
|||
create a function for Discount if qty > 50 then take 5% off total
I need to create a if function: if qty 50 then take 5% off of price.
|
#2
|
|||
|
|||
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(A150,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. "Einwomyn" wrote: I need to create a if function: if qty 50 then take 5% off of price. |
#3
|
|||
|
|||
if(A150,B1-(B1*.05),B1)*A1
-- paul remove nospam for email addy! "SierraRose" wrote: 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(A150,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. "Einwomyn" wrote: I need to create a if function: if qty 50 then take 5% off of price. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Create a function wher last digit is always set | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions |