How to make a cell copy N/A

Copper Contributor

I've a Production Tracker Spreadsheet.

 

We've a nesting column for each machine and then a column for production on each machine.

 

What I want is the production columns for the machines to lookup there Nested column. And if it equals N/A to put N/A in the processing Cell.

We do put values into the Nesting Columns other than N/A however I don't want them copied across unless it's N/A

 

JonShuard_0-1719484151539.png

 

4 Replies

@JonShuard Difficult to see with columns and row you should refer to but I believe you start in Q3.

Enter:

=IF(ISNA(J3),NA(),"")

 and copy down and across

@Riny_van_Eekelen

I Entered that and the Cell isn't showing a value.

Not sure what the issue may be there then

@JonShuard OK, perhaps I went to quick here. The N/A seems to be a text. I.e. not an N/A error message. Change the formula to:

=IF(J3="N/A",J3,"")

 

Thank you that's worked