$ in A1 returns a fee in A2

[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

 

[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

 

[Judi Tousley]

Yes, the VLOOKUP worked like a charm. If anyone else would like to see how I
set it up, write me at (e-mail address removed) and I'm happy to send a sample.

Judi