Need multiple IF questions & return a value from another worksheet

[tamij]

I have Column A = Balance & Column B = Interest Rate on my Master worksheet.
I also have a Rates worksheet that has several rate tiers that look a little
like this:
Column A Column B
..0015 Sweep <50,000
..0035 Sweep <100,000
From the Interest Rate column on the Master worksheet, I need it to say
somehting like, IF Balance <50,000 return cell A1 from Rates worksheet or IF
Balance is <100,000 but >50,000 return cell A2 from Rates worksheet. Any
help is greatly appreciated

 

[Jacob Skaria]

Assuming Balance is in A1 and the sheet is named "Rates"

=IF(A1<50000,Rates!A1,IF(A1<100000,Rates!A2,""),"")

 

[tamij]

Thank you for the help! What if Balance is not in A1? It's actually in F1
of my spreadsheet.

 

[tamij]

Sorry the last post I sent was a stupid question. I think I've looked at
this sheet too long. Thank you so much for your help!

 

[tamij]

Hey Jacob,
One more question. When I copy my formula to other cells, the formula keeps
increasing my cell # from the Rates worksheet. How do I keep the formula iin
tact during copy?

 

[Glenn]

Look at "Switch between relative, absolute, and mixed references" in the help file.

 

[tamij]

Thank you!

Look at "Switch between relative, absolute, and mixed references" in the help file.