I have 5 inputs that I need to output as a string of text in a single cell and I cannot figure out how to get it.
The 5 input cells will all read either “0” or “1”. So for example:
Cell C15: 1, D15: 0, E15: 0, F15: 1, G15: 1
Then I need the output either a “x” or a “o” for each of those inputs but in 1 cell. So for example:
Cell C20: oxxoo to match the inputs.
I tried doing this with the if function but could figure it out. I currently have 5 nested ifs that only return a single value.
=IF(C15=1, "o", IF(D15=1, "o", IF(E15=1, "o", IF(F15=1, "o", IF(G15=1, "o", "x")))))
and the output is o
The solution does not need to be an if function, if there is a better function to use please let me know.
Thank you.