Error message with nesting
On Wednesday, August 15, 2012 12:06:00 PM UTC-5, Bruce Bowler wrote:
On Wed, 15 Aug 2012 09:10:08 -0700, Pete wrote: I get the following error message when entering this formula... "You've entered too many arguments for this function." I need the entire formula. =IF(AND(I3=3),6,IF(AND(I3=5),1),IF(AND(I3=7),4),IF (AND(I3="A"),7),IF(AND (I3="C"),0),IF(AND(I3="G"),3),IF(AND(I3="K"),8)+,F (AND(I3="R"),5),IF(AND (I3="T"),9),IF(AND(I3="X"),2,"")) Help! Pete First comment would be that I think (I haven't done an exhaustive check) that none of your AND()s are needed. Looking at the first one, AND(I3=3) is equivalent to I3=3, so I think you can simplify the formula quite a bit. Second, look at what follows the '+' - is there a typo in that part of the equation? Bruce
Hi, yes, the "+" was a typo.
Here is what I canged it to..
=IF((I3=3),6,IF((I3=5),1,IF((I3=7),4,IF((I3="A"),7 ,IF((I3="C"),0,IF((I3="G"),3,IF((I3="K"),8,IF((I3= "R"),5,IF((I3="T"),9,IF((I3="X",2,""))
But now I'm getting the following error message:
"the specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format."
|