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.

Hi,

Enter this formula in cell F2

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

Enter this formula in cell F3

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

Regards

Govind.

Claude Laframboise wrote:
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.

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,"")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----