Help with Displaying figure between a range of percentages

[jeff2012]

Could someone please help me!
I am trying to figure out what I'm doing wrong. I want to have the user enter a loan amount and a percentage, then in my spreadsheet i have the particular rate appear that corresponds to information inputed above.

=IF(AND(C2<=250000),IF(AND(F2<=75%),DATA!J4),IF(OR(C2<=250000),IF(AND(F2>=76%,F2<=90%),DATA!J5,DATA! J6)))

This is what I have so far.

If loan amount is under 250,000 and greater than or equal to 76% and less than equal to 90% then return a figure on the sheet named Data J5. I have other conditions that I have to add to this as well. However if I can work out how to do these, then I should be ok.

Can anyone help me please

 

[Joe4]

I have removed your email address from the post above. It is never a good idea to post you email address on a public internet forum, unless you enjoy getting lots of Spam! Spambots routinely patrol public forums looking for email addresses to harvest. The best way to share an email address with someone is through a Private Message.