transfering numbers into teams

C

Claude Laframboise

I have 21 different team from 1 to 21. everytime a number appear in column,
ex: F1=5, then I would like to have in F2 the letter "R", and in F3 the
number "5"
could someone please let me know if it is possible to do this.
 
G

Govind

Hi,

Enter this formula in cell F2

=IF(ISNUMBER(F1),"R","")

Enter this formula in cell F3

=IF(ISNUMBER(F1),F1,"")

Regards

Govind.
 
M

Max

A subtle variant play which ensures that
the numbers entered in F1 are between 1 - 21 would be:

In F2: =IF(AND(F1>=1,F1<=21),"R","")
In F3: =IF(AND(F1>=1,F1<=21),F1,"")
 
Top