![]() |
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 |
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 |
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 |
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