Thread
:
How do I nest more then 7 IF's?
View Single Post
#
7
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
How do I nest more then 7 IF's?
Look in the help index for VLOOKUP
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"KenCanuck" wrote in message
...
Essentially I have a row of 13 dollar figures that I need to do a formula
that says =if(k1=a1,a2,if(k1=b1,b2,if(k1=c1,c2... Is there another way to
do
that?
"M Kan" wrote:
Are you trying to use this to catagorize a data set or summarize by
several
criteria? As far as I know, you can't nest more than 7 IF statements.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips
"KenCanuck" wrote:
I need to nest about 13 IF functions in one formula, can I do this?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett