If then formula for different percentages of a field based on value ranges?

Hi All:

Looking for some help on this:

Here is what I put in for the formulate but I get this error in my AS INITIAL OFFER BOX: #VALUE!

Here is what I have for the formula to start with so far but it is not working (once I got it working, then I was planning on addition other ranges):

=IF(AT1<3499,MAX(0,AT1*0.03%),IF(AT1>0,MIN(3499,AT1*0.03%),"")) 

The box AT INITIAL OFFER should show a predetermined % of AT TOTVAL (i.e. Total Value of a Asset I am wanting to purchase).

However depending on the total value of each item, I am increasing my total INITAL OFFER % based on 5 different Total Value (AT) ranges. See my screen shots. 

How do I need to write this formula to show the following?

If AT is greater than 0 but less than 3499 then 3% of AT 
if AT is greater than 3500 but less than 6499 then 5% of AT
if AT is greater than 6500 but less than 9999 then 8% of AT
if AT is greater than 1000 but less than 39999 then 15% of AT
if AT is greater than 40000 plus then 18% of AT

Can someone help me quickly?

See also the screen shots.

BIG SMILE!

:)

Greg

Here is a formula to try.  I think there is a better way to do this, but this works.  I split it over two lines to aid in viewing it.

=IF(AT2>=40000,MAX(0,AT2*0.18%),IF(AT2>=10000,MAX(0,AT2*0.15%),IF(AT2>=6500,MAX(0,AT2*0.08%),

IF(AT2>=3500,MAX(0,AT2*0.05%),IF(AT2>0,MAX(0,AT2*0.03%),"")))))

Note that in your original formula you were referencing AT1 and getting the #Value error.  The problem was that you have column headers in row 1.  You should have referenced AT2 instead.

Absolutely perfect...thanks so much...yea, I made the mistage of A1 instead of A2.

Just curious about any other better way you mentioned?

If you could post that would be very informative.

This is the final formula for this purpose...had to adjust a couple of things but it works based on what you sent me:

=IF(AT2>=40000,MAX(0,AT2*18.0177%),IF(AT2>=10000,MAX(0,AT2*15.0177%),IF(AT2>=6500,MAX(0,AT2*8.0177%),IF(AT2>=3500,MAX(0,AT2*5.0177%),IF(AT2>0,MAX(0,AT2*3.0177%),"")))))

:)

Greg