$ in A1 returns a fee in A2

J

Judi Tousley

WinXP, Excel 2002

Here is my scenerio:

If the amount of $0-10,000 is typed into A1, then the fee in A2 will be
$170.
If the amount of $11,000 is typed into A1, then the fee in A2 will be $175.
If the amount of $12,000 is typed into A1, then the fee in A2 will be $180.

These fee amounts in A2 go on and on...and the increments are not always $5.

QUESTION: What formula do I put in A2 to get the correct fee?

Judi
 
J

Judi Tousley

In reading further, I'm wondering if a VLOOKUP formula might work...but I'm
not sure how to set it up. Since there are so many fees based upon the
amount typed in A1, maybe there should be a huge table set up and then
somehow referenced in the formula in A1 and/or A2...?

Judi
 
Top