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
----