Thread: Updating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default 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