Formula for Tiered fee rates

Hi all,
I'm trying to find the correct formula for calculated tiered fee rates. I have the following to determine for any amount up to $500,000:

Min Max Rate
Tier 1 $0.00 25,000.00 1.00%
Tier 2 $25,000.01 50,000.00 0.75%
Tier 3 $50,000.01 100,000.00 0.50%
Tier 4 $100,000.00 500,000.00 0.25%

Most answers I'm seeing are similar to this:
=IF(AND(CELL1>0.00,
CELL1<25000.00),
CELL1*0.01,
IF(AND (CELL1>25000.01,
CELL1<50000.00),
CELL2*0.0075,)


Anyone know if this would be correct? I'm not sure what values need to be replaced in order to work correctly within my worksheet.

Thanks!
Sam

Does this help Sam

=LOOKUP(D1,{0,25001,50001,100001},{"1.00%","0.75%","0.5%","0.25%"})

Change the D1 to where your value is.

Windy