how do I get the best interest rate from different columns

**raw_geek** · 04-16-2012, 03:58 PM

Have 3 columns

A has funds
B column has minimum Guaranteed Interest Rate
C column has current interest rate

Current interest rate and minimum Guaranteed Interest Rate are different. Client will get which one is higher Interest Rate.

Question.:When I select the funds on E10(drop-down Lists) how do I get the best interest rate on F10(from B and C)

More in attached sheet

**raw_geek** · 04-16-2012, 04:52 PM

any help????????

**icestationzbra** · 04-16-2012, 06:05 PM

please do not duplicate posts - you are wasting people's time:

http://www.excelforum.com/excel-gene...rest-rate.html

how do I get the best interest rate from different columns

LinkBack

Thread Tools

Rate This Thread

Display

how do I get the best interest rate from different columns

Re: how do I get the best interest rate from different columns

Re: how do I get the best interest rate from different columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions