Trying to return value from another sheet with ranges

May 17, 2012 at 19:29:37
Specs: Windows 7
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.


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

See More: Trying to return value from another sheet with ranges

Report •

May 17, 2012 at 19:48:01
The syntax for your AND and OR is wrong.

Read the Excel Help files to see how they should be used.

Since AND and OR are used to compare 2 or more objects, using something like:


makes no sense.

Perhaps you are looking for something like this:

IF(AND(C2<=250000, F2<=75%)....

which means that both of those conditions must be TRUE for the IF to be TRUE.

For OR, it would be:

IF(OR(C2<=250000, F2<=75%)....

which would mean that any one of those would have to be TRUE for the IF to be TRUE.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

May 17, 2012 at 19:55:01
Thanks for the help, I tried the following:-


It is still resulting in a false statement in the cell, when it should be producing a rate.

Are you able to shed any light on this?


Report •

Related Solutions

Ask Question