Offset a formula result

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

Patrick C. Simonds

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Results of Formulas 1
Excel VBA 1
Show the formula not the result 3
Excel Need Countifs Formula Help 0
Set the Length of the Cell 1
formula displays as a formula, not as its result 1
count - but exclude counting cells with a formula 4
formula errors 2

Back
Top