View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brucas brucas is offline
external usenet poster
 
Posts: 4
Default Convert 0 value cells to "text"

I am trying to create a formula that will convert cells that are either blank
or displaying a 0 value to displaying "RDO" BUT if I enter a value other than
0 I want it to display that value.
I tried several different things but I am not having any success. Hopefully
someone with much more knowledge than me can help...