Show a result based on numbers that match a scale

[onefastmx5]

Hi, this should be really easy but im stumped.

A1 needs to show "0.95%", or "0.8%", and so on, based on a figure entered into A2. Doesnt need to calculate the percentage out or anything, just return a figure based on A2 being within a certain range. Im confused by IF and AND and cant get that to work as there are more than 3 ranges, and have tried MEDIAN, but doesnt want to work for multiple ranges. Any help greatly appreciated.


The percentages and ranges are below:

0.95%		$0	$149999
0.80%		150000	249999
0.60%		250000	399999
0.45%		400000	749999
0.30%		750000	+

<tbody>
</tbody>

<tbody>
</tbody>

 

[cyrilbrd]

considering your formula in A1
your value of interest in A2

Your table located anywhere on your sheet.
Named range this range:
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-page-orientation:landscape;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {mso-number-format:Percent; text-align:right; vertical-align:middle; white-space:normal;} --> </style>

0.95%

0.80%

0.60%

0.45%

0.30%

<tbody>
</tbody>

as "percent"

and this range:

0

150000

250000

400000

750000

<tbody>
</tbody>

as "range"

in A1 type:
=LOOKUP(B1,range,percent)

is this close to what you needed?

 

[onefastmx5]

Youre a legend! SOLVED!

Thanks
Adam.

 

[cyrilbrd]

SOLVED!

Thanks for the feedback.

Thanks

You are welcome.