Excel 2007 Help

Closed
Angel - Sep 22, 2009 at 07:31 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 22, 2009 at 10:00 PM
Hello,

I have a drop down on C19 with the following listings. A, B. If A is selected i would like to have the word "Stop" display on a cell. How do I do this?

Thanks,
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 22, 2009 at 10:00 PM
In an empty cell preferably in the same row type the formula

=if(c19="A","Stop","")
0