ExcelBanter - Offset a formula result

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Offset a formula result (https://www.excelbanter.com/excel-worksheet-functions/239874-offset-formula-result.html)

Patrick C. Simonds

Offset a formula result

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

Bob Phillips[_3_]

Offset a formula result

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

All times are GMT +1. The time now is 11:45 AM.