Need more =if functions

[Guest]

I'm trying to do an if,then function that looks at data in a cell and
compares to 13 different possible results but excel on allows 7 nested IF
functions. Any thougths on how to complete this task?

This is in regards to banking. The function should look at the term (13
different terms) and based on the term should return the appropriate rate.

Thanks

 

[Jason Morin]

With that many, I would use a VLOOKUP. To learn how to
use a VLOOKUP, see:

http://www.contextures.com/xlFunctions02.html

Or, if you're dead set on IFs, you could always
concatenate them:

=IF(A1=1,1.3%,"")&IF(A1=2,3%,"")&IF(A1=4,6.5%,"")&IF
(A1=5,2.2%,"")&IF(A1=6,4.4%,"")&IF(A1=9,7%,"")&IF
(A1=10,7.5%,"")&IF(A1=11,8.8%,"")&IF(A1=3,3.5%,"")&IF
(A1=12,4.9%,"")&IF(A1=13,1%,"")&IF(A1=7,1.6%,"")&IF
(A1=8,6.25%,"")

HTH
Jason
Atlanta, Ga