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

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.

"Einwomyn" wrote:

> I need to create a if function: if qty >50 then take 5% off of price.

if(A1>50,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(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.
>
> "Einwomyn" wrote:
>
> > I need to create a if function: if qty >50 then take 5% off of price.

I need to create a if function: if qty >50 then take 5% off of price.

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.

"Einwomyn" wrote:

> I need to create a if function: if qty >50 then take 5% off of price.

if(A1>50,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(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.
>
> "Einwomyn" wrote:
>
> > I need to create a if function: if qty >50 then take 5% off of price.