formulas

[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

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--(A1>{0;250;500}),(A1-{0;250;500}),{0.25;0.1;0.15})

 

[Frank Kabel]

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

 

[Jason Morin]

One way:

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

Format the cell as %.

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

Format the cell as %.

Or currency perhaps?

 

[Jason Morin]

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