Updating

[Aaron Neunz]

I type a value in an Excel cell, let's say a value of "True". Based on that
value I would like a cell in another column to automatically update to a
value, let's say "A." How can I accomplish this?

Thanks in advance,
Aaron Neunz

 

[JulieD]

Hi Aaron

in the cell that you want to update type
=IF(A1="True","A","")
this will display "A" if true is typed into A1, otherwise the cell will
display nothing

Hope this helps

Cheers
julieD

 

[Aaron Neunz]

Simple enough. That helps alot.

Thank You

Hi Aaron

in the cell that you want to update type
=IF(A1="True","A","")
this will display "A" if true is typed into A1, otherwise the cell will
display nothing

Hope this helps

Cheers
julieD

 

[JulieD]

glad to assist.

Simple enough. That helps alot.

Thank You