excelexcel-formulatextformattingcell

EXCEL randbetween- text representation - clarification


I have made a simple coin toss in EXCEL, and understands what the formula does and what the outcome may be.

=TEXT(RANDBETWEEN(0;1);"""HEAD"";;""TAILS""")

Can someone explain what all the double/triple qoutes does?

Below would be a more logical way to do it for me

=TEXT(RANDBETWEEN(0;1);"HEAD";"TAILS")

Need an explanation for a formula.


Solution

  • This is the logic of the TEXT function.