MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I can't output text from an if statement when many programs are in one field

Posted by Kyle on August 20, 2001 3:21 PM

I am working on a reference template for the company I work for, and I need one of the fields to output a letter according to the number entered in another field. I can get this to work if I only have one if statement in a field, so I know I've got the format correct, and I am using the exact same format for other fields that return a simple number, which have more IF statements in it that the field I have this problem with. Currently, I use the CHAR(##) function, with CHAR(65) being the numerical representation for A, and so on. I have also tried the TEXT function, but to no avail. I would deeply apprectiate any suggestions.

Posted by Kyle on August 20, 2001 6:24 PM

Example of functional and disfunctional programs, still need help!

This is the one that works...


This is the one that does not...


Posted by Aladin Akyurek on August 21, 2001 12:06 AM

What is...

147479? Your formula will also not "work" if E4=0, 1, or 100. What are you trying to accomplish?

Posted by Kyle on August 21, 2001 3:30 PM

Re: What is...

147479 is just an overhead number for some parts our company makes here, and is further defined by using a "-" and then a sequence of one or two letters. I have an error message set up in case anyone enters any value not within the desired range. what I would actually like to do, is to be able to read E4 and output the necessary suffix for the entered value.

Posted by Aladin Akyurek on August 21, 2001 4:18 PM

Re: What is...

Ok, Kyle. Now I understand (I think).

This could be what you're after:


You can put 147179 in some cell, say, A1 and use A1 instead in the above formula.