- Jul 20, 2001
- 70,229
- 28,939
- 136
I have chemical analylical results stored in two columns, A and B. I want to add them together. Sometimes one or the other number is not a number but an "ND" indicating that the result was below the dection limit for the analyis. In this case I would like the formula to return the value of the chemical that was detected. In some cases, neither were detected in which case I'd like "ND" returned.
The following will return A+B if both A and B are numbers or ND if one or the other is not a number.
=IF(ISERROR(A1+B1),"ND", A1+B1)
Any ideas on how to get the result I'd like?
For bonus cookies, I'd like conditional formatting to change the font color for cells where only one chemical result was a number.
The following will return A+B if both A and B are numbers or ND if one or the other is not a number.
=IF(ISERROR(A1+B1),"ND", A1+B1)
Any ideas on how to get the result I'd like?
For bonus cookies, I'd like conditional formatting to change the font color for cells where only one chemical result was a number.
Last edited by a moderator: