ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating (https://www.excelbanter.com/excel-programming/303031-updating.html)

Aaron Neunz

Updating
 
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

Updating
 
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" wrote in message
...
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





Aaron Neunz

Updating
 
Simple enough. That helps alot.

Thank You

"JulieD" wrote in message
...
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" wrote in message
...
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

Updating
 
glad to assist.

"Aaron Neunz" wrote in message
...
Simple enough. That helps alot.

Thank You

"JulieD" wrote in message
...
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" wrote in message
...
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










All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com