ExcelBanter - transfering numbers into teams

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - transfering numbers into teams (https://www.excelbanter.com/excel-worksheet-functions/35031-transfering-numbers-into-teams.html)

Claude Laframboise

transfering numbers into teams

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.

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.

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

All times are GMT +1. The time now is 05:07 PM.