Is there any way to write a formula the puts the result as text in the cell
just to the left of the cell the formula is in?

Example:

=IF(H229=$AA$5,"Yes","No")

This formula resides in cell AB229 but I want the resulting value to appear
in cell AA229