assign a value to a range

  • Thread starter Thread starter travelersway
  • Start date Start date
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
 
I'm glad it worked for you. Thanks for the feedback, it is alway
appreciated.

Cheers
 
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)))
 
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
How do I Return a Value Using Multiple Criteria? 1
count blank cells to next value 7
Different cells that need to sum in one 4
Freight formula 1
Consolidated Values for a Pie chart 1
Formulas--NEED HELP! 4
PLEASE HELP! Return a Value Using Multiple Sources 4

Back
Top