macabre100
New Member
- Joined
- Mar 25, 2005
- Messages
- 29
I am trying to eliminate zeroes & "#n/a" or any other kind of errors from a list and replace it with a number.
I'm using the formula "=if(or(ISERROR(A1),A1=0),170,A1)". However, this formula only eliminates the zeroes, but keeps other errors. Am I missing something here?
Thanks in advance!!
I'm using the formula "=if(or(ISERROR(A1),A1=0),170,A1)". However, this formula only eliminates the zeroes, but keeps other errors. Am I missing something here?
Thanks in advance!!