"Pran" wrote:
I have 4 cells,
if 1st cell has number, then result is "A"
if 1st & 2nd cell has number, then result is "B"
if 1st,2nd & 3rd has number, then result is "C"
if all cells has number, result is "D"
How can i make this function?

=IF(ISNUMBER(A1),IF(ISNUMBER(A2),IF(ISNUMBER(A3),I F(ISNUMBER(A4),"D","C"),"B"),"A"),"in
process")