Thread: Multiple "IF" statements every cell in range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cbrd[_28_] cbrd[_28_] is offline
external usenet poster
  
Posts: 1
Default Multiple "IF" statements every cell in range

I have a column (B) and every cell from B4 to B4444 I wish to insert
multiple IF statements life the following:

If I type "gm" (no quotes) into any cell from B4 to B4444, i wish for
excel to change it to "General Motors"
If I type "am" (no quotes) into any cell from B4 to B4444, i wish for
excel to change it to "American Motors"
If I type "ha" (no quotes) into any cell from B4 to B4444, i wish for
excel to change it to "Honda America"
If theres any other text typed into the cell, excel leaves as is.

Any tips?


--
cbrd
------------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...o&userid=30009
View this thread: http://www.excelforum.com/showthread...hreadid=500125

Reply With QuoteReply With Quote