Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need more =if functions
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 |
#2
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions | |||
Where can I see VBA code for financial functions? | Excel Worksheet Functions |