Help with IF AND Statements

**jeff2012** · 05-20-2012, 08:52 PM

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

**FDibbins** · 05-20-2012, 09:01 PM

try...

=if(and(loan-amount<250000,loan-amount>=0.76,loan-amount<=0.9),!DataJ5,whatever-else-you-want-to-show)

the =and() works like this...
and(condition1,contition2,condition3)
so combining that with an if() gives you....
=if(and(condition1,contition2,condition3),option1, option2)