Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DDE updating | Excel Discussion (Misc queries) | |||
Updating | Excel Discussion (Misc queries) | |||
Updating | Excel Worksheet Functions | |||
DDE and updating | Excel Discussion (Misc queries) | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |