formulas

  • Thread starter Thread starter vince
  • Start date Start date
V

vince

How would I do a formula as follows: thanks in advance.
0-$250.00 pays 25%
$250.01 - 499.99 pays 35%
500.00 + pays 50%

Thanks for the help.

Vince
 
vince said:
How would I do a formula as follows: thanks in advance.
0-$250.00 pays 25%
$250.01 - 499.99 pays 35%
500.00 + pays 50%

Thanks for the help.

Vince

Hi Vince
one way (if your value is stored in A1):
=IF(A1>=500,A1*0.5,IF(A1>=250.01,A1*0.35,IF(A1>=0,A1*0.25)))

Frank
 
One way:

=SUM((A1>{0,250,499.99})*{0.25,0.1,0.15})

Format the cell as %.

HTH
Jason
Atlanta, GA
 
I set up my formula to return a % (25%, 35%, or 50%). If
they want to multiply that % by the dollar value in A1,
then yes, format as currency.

Jason
 
Back
Top