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

 

[T. Valko]

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

Like this...

=IF(AND(C2<>"",C2<=250000,F2>=0.76,F2<=0.9),.......

 

[jeff2012]

Hi,

I was wondering if I could send the spreadsheet to you and see if you can work it out. I'm still having trouble telling the program what I what it to do?

Thanks.

 

[paddydive]

Is this what you want to do
if c2 <=250000 and f2 <=75% then data!J4
if c2 <=250000 and f2 between 76% to 90% then data!J5
else data!J6

Try this :

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

 

[jeff2012]

Thanks Paddy,

That is what i'm trying to achieve. It is coming up with a value of false. How can I change this to show the actual rates on the Sheet DATA?

Thanks

 

[paddydive]

For which value in Cell C2 and F2 it is showing as False ?
What value is in Data J4,J5,J6 ?

 

[jeff2012]

On DATA sheet J4J5J6
They are Interest Rates (so percentages)

The C2 and F2 are user input cells and it is coming up false in the cell J9 which is where I need it to display the interest rate.

Hope this helps

 

[paddydive]

Sorry Jeff... i m kind of confused...

You said cell J9 is showing the value as False, But our formula has nothing to do with cell J9....

Are you coping the formula to different cells, in that case the ranges will also change you need to change cell reference to absolute cell referencing.

if i m not getting it correctly, can you paste it. so that i can have an idea ...Thanks

 

[jeff2012]

Sorry Paddy,

J9 is on the sheet where I want everything displayed and that is the cell which i'm writing the formula.

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

DATA SHEET
J4 = 6.37%
J5 =6.47%
J6= 6.57%

DISPLAY SHEET

Loan Amount = $.......(user Input) this is C2

LVR = .....%(user Input) this is F2

Hope this helps explain. Otherwise I could send you the spreadsheet

Thanks Paddy.

 

[paddydive]

Hi Jeff

Working fine on my machine, just one more question, if cell J9 is on the DISPLAY SHEET ?

what are the values in cell C2 and F2 which gives result as False.