Forum Discussion
JonShuard
Jun 27, 2024Copper Contributor
How to make a cell copy N/A
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 look...
JonShuard
Jun 28, 2024Copper Contributor
Riny_van_Eekelen
I Entered that and the Cell isn't showing a value.
Not sure what the issue may be there then
I Entered that and the Cell isn't showing a value.
Not sure what the issue may be there then
Riny_van_Eekelen
Jun 28, 2024Platinum Contributor
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,"")
- JonShuardJun 28, 2024Copper ContributorThank you that's worked