Thread: how to format a column to corespond with another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default how to format a column to corespond with another
Put this in E1:

=IF(B1=0,"N/A","")

and copy down.

Hope this helps.

Pete

On Dec 3, 9:09*pm, 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