Thread: how to format a column to corespond with another
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default how to format a column to corespond with another
=REPT("N/A",B1=0)


"JeremyC." wrote:

I want to make column "E" read "N/A" when column "B" reads "0". How do i do it?
Reply With QuoteReply With Quote