HI Bob, essentially I have a row of 13 dollar figures, and my formula goes
like this... =if(k1=a1,a2,if(k1=b1,b2,if(k1=c1,c2,... Another way to do
that where I don't nest 13 IF's?? Thanks

"Bob Phillips" wrote:

If you don't have Excel 2007, you can't. If you do have Excel 2007, you
shouldn't.

Tell us what you are trying to do, in words, there is bound to be a better
way.

--
__________________________________
HTH

Bob

"KenCanuck" wrote in message
...
I need to nest about 13 IF functions in one formula, can I do this?