Hi all,
There have been a couple of times where I've wanted to use the IF statement in excel but find it doesn't quite fulfill what I need it to do. One specific simple example is this:
Say you wanted to programme a simple coin toss...
If you input "Y" into C7, the output will either be "H" for heads, or "T" for tails.
What I want to do is this:
=IF(C7="Y","H"OR"T"," ")
Basically I need something to facilitate the function of OR here, so that I can have more than one variable returned if the input in C7 is...inputted.
Does this make sense?
Idk, help someone pleeease