"Joy" wrote:
I tried it but it came back with a True answer for all of them and I need to
say either 1,2,3,4 or 5.

Not sure what happened over there. The formula will either return a blank:
"", or the numbers: 1,2,3,4,5 as per your specs depending on the contents in
A1:B1.

Suggest you just try copying the entire formula from my post, then paste
directly into the formula bar for C1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---