Then you have to have the formula in AA229.

--
__________________________________
HTH

Bob

"Patrick C. Simonds" wrote in message
...
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