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!



Posted by Thomas Venn on January 19, 2000 10:10 AM


A B
------------------------------------------------
1| 101 =IF(A1>100,"trophy","no trophy")
2| 100 =IF(A2>100,"trophy","no trophy")
3| 50 =IF(A3>100,"trophy","no trophy")
4| 10 =IF(A4>100,"trophy","no trophy")