Offset a formula result

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

Set the Length of the Cell 1
Show the formula not the result 3
Excel Need Countifs Formula Help 0
formula displays as a formula, not as its result 1
Excel VBA 1
Match function: error due to format? 4
Why does forumula show in cell instead of formula result? 2
OFFSET and LOOKUP Error 1

Top