assign a value to a range
 

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


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=480863

assign a value to a range
 

one way:

B1: =IF(A110,5%,IF(A19,4%,IF(A18,3%,0)))

Good luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=480863

assign a value to a range
 

Thank You Bruce! You always come through!
Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=480863

assign a value to a range
 

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

Cheers!


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=480863

assign a value to a range
 

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=480863

assign a value to a range
 

Thanks Cutter.

Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=480863

assign a value to a range
 

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

Good catch.

Cheers.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=480863

assign a value to a range
 

Glad to help.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=480863