MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Class detector...


Posted by IgOR on July 16, 2001 5:04 AM

Hello again..

I'm working on detecting student in which class they should be...
i've got the student name is cell A2 while the class which the student should be
is in cell B2

If there is number or text entered in cell A2Â…even a single number or text ,
cell B2 will show " 2 EXCELLENT "..if nothing entered in cell A2..cell B2..will show nothing


Posted by IgOR on July 16, 2001 5:10 AM

Before I forget..I'm hoping something like formula to solved this thing ..
thanks

Posted by Alix on July 16, 2001 6:09 AM

Hi IgOR

Enter the formula below in cell B2

=IF(A2="","","2 Excellent")

the "" represents no entry.
Alix

Posted by IgoR on July 16, 2001 7:17 AM

Thanks Alix..you are excellent