K
killertofu
I am trying to make a check for codes, so that if the number code i
already assigned to something it will show "USED" next to it.
My formula now is, A2=IF(A1>=0,"USED","UNUSED"). That means that i
there is a number in A1, then A2 will show USED, if not, then UNUSED.
My problem is, that if A1 is left blank, then A2 is left blank.
still want it to say UNUSED even if it is blank.
Furthermore, if someone can tell me how I can have A2 check fo
anything in A1, not just >=0 numbers. That way, if I wanted to have A
check for text, it would tell me USED if there was text in A1, an
UNUSED if it was empty.
Thanks
already assigned to something it will show "USED" next to it.
My formula now is, A2=IF(A1>=0,"USED","UNUSED"). That means that i
there is a number in A1, then A2 will show USED, if not, then UNUSED.
My problem is, that if A1 is left blank, then A2 is left blank.
still want it to say UNUSED even if it is blank.
Furthermore, if someone can tell me how I can have A2 check fo
anything in A1, not just >=0 numbers. That way, if I wanted to have A
check for text, it would tell me USED if there was text in A1, an
UNUSED if it was empty.
Thanks