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