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