am i able to use more than 7 if conditions in one input? if not, is there another way i can do it THAT IS SIMPLE? What's the simpliest way I can do if conditions that's passed 7?
am i able to use more than 7 if conditions in one input? if not, is there another way i can do it THAT IS SIMPLE? What's the simpliest way I can do if conditions that's passed 7?
Usually there are simpler, more efficient methods than multiple IFs or nested IFs. You can work round the limit of 7 but it's normally easier to use some sort of LOOKUP, VLOOKUP or even CHOOSE function.
Can you give a little more detail?
I aree with DLL that there's normally a better way but, if you have to go down this route, then look at Chip Pearson's site
http://www.cpearson.com/excel/nested.htm
Ed
_____________________________
Always learning, but never enough!
_____________________________
well if i do a vlookup i get "#n/a" if the value isn't found. Is there a way I can have it as blank if there's no value? for IF conditions, I am able to set any false as "" which is blank.
You can use the conjugated method of joining IF statments to pass the seven max. Example:
=IF(A1=1,"A is 1","")&IF(A1=2,"A is 2","")&... You can go as many as you want this way.
Remember the max characters you can have on one line is 1024 so if you are doing a lot of IF statments you may surpass that limit, which means you will have to either use a macro or VLOOKUP().
For the VLOOKUP() error you could probably setup a =IF(ISERROR(VLOOKUP(...)=TRUE),"", "Otherwise, display the result here.")
Last edited by Tracer123; 06-19-2008 at 01:59 PM.
ok i think that will work. i'll try it out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks