LOOOOONG formula, with drop down selection

[MichaelJ]

I am way over my head! I am trying to write a formula that includes the
selection of a drop down list in cell H5: If any of 5 names is selected, the
a set of formulas applies, if the 6th name (other) is selected, then a
seperate set of formulas applies.
To further complicated, the formulas reference a value in another cell (E9),
which has 'ranges' that dictate which formula to use, i.e., a) 20,000 or
less is one formula, b) 20,001 to 50000 is another formula, c) 50,001 to
100,000 is yet another formula, d) 100,001 to 1,000,000 is another formula,
e) 1,000,001 to 4,000,000 is another formula, and f) 4,000,001 and up is the
last formula.

Each formuala adds a $ amount to the result of the formula, which accounts
for the amount below the minimum number.

The result in the target cell G25 is the actual premium for Title Insurance,
at a specified purchase price E9 in a specific or other county, H5.

=IF($E$9<=100000,($E$9-50000)*(3/1000)+280,0)

This formula does not work because if the entry is $40,000, it calculates it
by subtracting 10000*3/10000 (40,000 - 50,000), and subtracts it from the end
number to be added of $280 = @250. It should read somehow to not use this
section if the number is not greater than or equal to $50,001 and less than
or equal to $100,000.

This is way over my head and I am just a lone real estate agent without an
IT brain!!!

Can anyone help?

 

[Jacob Skaria]

Use ANd()

=IF(AND($E$9>50000,$E$9<=100000),($E$9-50000)*(3/1000)+280,0)

If this post helps click Yes