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 ..

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


Enter the formula below in cell B2

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

the "" represents no entry.

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

Thanks are excellent