Sazzle scott
New Member
- Joined
- Feb 1, 2004
- Messages
- 10
I am trying to write an If statement that check if a cell has an ERROR.TYPE=7 it will appear as " " if false it will return the value of the cell. However it does not recognise the FALSE statement to return the value;
IF(ERROR.TYPE(B8)=7,"",B8)
I will have #N/A! 's in the main worksheet
I could create a another table to filter it out but I thought there has to be an easier way.
IF(ERROR.TYPE(B8)=7,"",B8)
I will have #N/A! 's in the main worksheet
I could create a another table to filter it out but I thought there has to be an easier way.