NEWBIE ALERT*:
OK, please bare with me.

What is the method for combining multiple if statements in one cell's
formula?

In English, the formula would be something like:

"If cell B3 is less than 1000 then display the price that is in cell F2, if
cell B3 is more than 1000 but less than 2000 then display the price that is
in cell F3..etc, etc..."

Besides HOW to write that formula, I have a question: How many conditions
can be combined in one formula? I have about 20 different "less than or
greater than" items.

Is this the best way to accomplish this? (I suspect NOT)

Thanks for reading!