Hi beechum

OK, I was not looking for an argument, I was just pointing out
inconsistencies. If you really want to use an IF formula, there is only one
way of doing it in a situation like this one , and that is by using a helper
column, and then splitting the IF statement over these columns. In the first
column, you will evaluate say 6 IF statements, giving a value when true. For
the False part, give a unique number, letter or something. I like using "NOT
DONE". In the second column, you start your IF statement with
=IF(B1<"NOT DONE",B1,IF( and add the rest of the formula to evaluate the
remaining possibilities. In this way, you will either get a code, or the
words NOT DONE in the first column. In the 2nd column you will carry forward
the codes from the previous column, and also evaluate the NOT DONE ones, so
that you will have only codes in this column. Hide the first column, as you
do not need to see it, and voila.

Hth



"beechum1" wrote:


kassie.... i'll check out the vlookup command.... I of course, am just
getting started. as far as the 031 thing.... i have the IC031,
ID031... or will have had... if i were to complete proofing the
code.... all of them in alphabetical order, so that IF ic031 wasn't
found, and IF ID031 wasn't found, all the way to the XD031, then all
the remaining 031's will return the proper code... so perhaps i didn't
proof it, but it seems to me that the way i would have finalized it,
would have worked. the capitolization also is just not having been
proofed... once i found out that i couldn't use the line as is, i
didn't proof it.


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=501427

ok.... i like that idea... seeings how i don't know how to do much else,
that makes alot more sense than trying to learn something i really don't
need.

and i wasn't fightin... just saying..... I planned on proofing it as i
went, but when i found it didn't work, i didn't proof it anymore....
thanks though, i know what your saying......

So 7 level IF statements is the max then??? I guess I'll find out here
in a minute hahaha.


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=501427

Hi Beechum

Remember, the last condition you should evaluate, is the RIGHT(B1,3) ones.
Also, make use of the IF(OR( formula to group your results. Iow, all
numbers evaluating to say "l", can be grouped togeterwith the OR bit, to
reduce the number of IF's

"beechum1" wrote:


ok.... i like that idea... seeings how i don't know how to do much else,
that makes alot more sense than trying to learn something i really don't
need.

and i wasn't fightin... just saying..... I planned on proofing it as i
went, but when i found it didn't work, i didn't proof it anymore....
thanks though, i know what your saying......

So 7 level IF statements is the max then??? I guess I'll find out here
in a minute hahaha.


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=501427

PERFECT.... thanks alot.... the OR will work perfect for what i'm
doing... thanks


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=501427