Hello
I can have any of these values (0,1,2,3,4) in in A1.
how do I Make B1 return the following:
if 0 then return "NS"
if 1 then return "G"
if 2 then return "A"
if 3 then return "R"
if 4 then return "C"
how can i write this formula in one line so that it picks up whatever is in A1 and returns the appropriate in B1?
MANY THANKS!
I can have any of these values (0,1,2,3,4) in in A1.
how do I Make B1 return the following:
if 0 then return "NS"
if 1 then return "G"
if 2 then return "A"
if 3 then return "R"
if 4 then return "C"
how can i write this formula in one line so that it picks up whatever is in A1 and returns the appropriate in B1?
MANY THANKS!