The following syntax results in either Yes or No being displayed in the cell
depending on whether or not the value is 55. =IF(A2=55,"Yes", "No")

How can program the cell to display one of several results depending on the
value entered in cell A2?

For example:
If A2 is 55, A1 should display ABCDEFG
If A2 is 56, A1 should display HIJKLMOP
If A2 is 57, A1 should display QRSTUV