transfering numbers into teams

[Guest]

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.

 

[Govind]

Hi,

Enter this formula in cell F2

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

Enter this formula in cell F3

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

Regards

Govind.

 

[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,"")