how to format a column to corespond with another

[JeremyC.]

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

 

[Pete_UK]

Put this in E1:

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

and copy down.

Hope this helps.

Pete

 

[Teethless mama]

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