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%,"")&I F
(A1=8,6.25%,"")
HTH
Jason
Atlanta, Ga
-----Original Message-----
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
.