Excel 2007 Help

Closed
Angel - 22 Sep 2009 à 19:31
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 22 Sep 2009 à 22:00
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
22 Sep 2009 à 22:00
In an empty cell preferably in the same row type the formula

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