ExcelBanter - how to format a column to corespond with another

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to format a column to corespond with another (https://www.excelbanter.com/excel-worksheet-functions/250063-how-format-column-corespond-another.html)

JeremyC.

how to format a column to corespond with another

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

Pete_UK

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?

Teethless mama

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?

All times are GMT +1. The time now is 12:58 PM.