How do I create automatic titles in one cell, depending on the value in another?
Posted by Andrew Heathcote on January 19, 2000 2:48 AM
I have a column filled with months, an accumulative frequency, and when it reaches a certain value, the adjacent cell needs to give the title of a trophy, indicating that a certain person has worked for, say, 100 months. I was wondering if this could be done by programming, something like:
if C1>100 print "trophy"
I have limited programming knowledge as you can see!