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

 

[jeff2012]

They are variable(changing)values.

This is the user input, it can be changed and depending on the loan amount and the LVR amount, depends which rate is displayed in the J9 cell.

I wonder why it isn't working for me. Are you using the same formula that I sent you?

 

[paddydive]

Yes Jeff... This is what i used

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

Can you copy paste same, and let me know, it is also working fine if i change the loan amount and LVR

 

[jeff2012]

email address removed, per forum rules

This is my email address are you able to email me, then I can send you screenshots or even the acutal spreadsheet

Thanks Paddy

 

[jeff2012]

Yes Jeff... This is what i used



Can you copy paste same, and let me know, it is also working fine if i change the loan amount and LVR

Yeah it doesn't appear to be working, I copy and pasted this in the spreadsheet. It is still coming with false, no matter what you enter in the loan amount and lvr.

 

[paddydive]

I got your problem Jeff.... i think you are using below formula which you have mentioned in earlier message.

Jeff...

Your 1st formula had error, i think you are using this formula

=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 formula has error in AND & 3rd IF statement. Replace it by below formula :

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

If you still face problem let me know

 

[vlady]

can you also try this one from above formula...

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

 

[paddydive]

Jeff,

You can try Vlady's formula also...

Thanks Vlady

 

[jeff2012]

Thanks Vlady,

However that didn't seem to work either

 

[paddydive]

Jeff..

Plz send your excel to me on my email... pls check you messages

 

[jeff2012]

Hi Paddy,

I have replied to your private message and sent it your email address.

Thanks.