assign a value to a range

[travelersway]

I'm trying to assign a percent value associated with a dollar value within a range.
How would I write this formula?

EXAMPLE:

LOCATI0N
B1 IF A1 = OR > $10.00, 5%,0
B2 IF A1 < $10.00 AND = OR > $9.00, 4%,0
B3 IF A1 < $9.00 AND = OR > $8.00, 3%,0

Help appreciated.
TRAVELERSWAY

[swatsp0p]

one way:

B1: =IF(A1>10,5%,IF(A1>9,4%,IF(A1>8,3%,0)))

Good luck.

[travelersway]

Thank You Bruce! You always come through!
Travelersway

[swatsp0p]

I'm glad it worked for you. Thanks for the feedback, it is always appreciated.

Cheers!

[Cutter]

Bruce's formula doesn't account for the part of your original request for values that equal 10, 9 or 8.

The formula to cover that would be:

=IF(A1>=10,5%,IF(A1>=9,4%,IF(A1>=8,3%,0)))

[travelersway]

Thanks Cutter.

Travelersway

[swatsp0p]

Thanks, Cutter. I missed the part of the OPs request that stated '='...

Good catch.

Cheers.

[Cutter]

Glad to help.