U_Shrestha
04-06-2010, 06:50 AM
Hi,
In the attached table, I need to compare two corresponding data and need to determine if the data increased, decreased or remained the same. I used "If" function like this:
IF(B2>A2,"Increased",IF(B2<A2,"Decreased",IF(B2=A2,"No change","Check!")))
The problem with my data is that some of the data has text instead of number which is "ND". What I am looking for is, can the IF function somehow consider ND as "0" and then perform the calculation because I got a error with my current function when there was "ND" in one of the cell (please see C11, the data should have been "Decreased").
Can someone help? Thanks.
In the attached table, I need to compare two corresponding data and need to determine if the data increased, decreased or remained the same. I used "If" function like this:
IF(B2>A2,"Increased",IF(B2<A2,"Decreased",IF(B2=A2,"No change","Check!")))
The problem with my data is that some of the data has text instead of number which is "ND". What I am looking for is, can the IF function somehow consider ND as "0" and then perform the calculation because I got a error with my current function when there was "ND" in one of the cell (please see C11, the data should have been "Decreased").
Can someone help? Thanks.