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
