assign a value to a range

T

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
 
S

swatsp0p

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

Cheers
 
C

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)))
 
S

swatsp0p

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

Good catch.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I don't know which formula to use? 4
count blank cells to next value 7
Different cells that need to sum in one 4
How do I Return a Value Using Multiple Criteria? 1
Freight formula 1
Formulas--NEED HELP! 4
PLEASE HELP! Return a Value Using Multiple Sources 4
Formula required 5

Top