Check a cell’s value for a numerical value or null or space/(s)

[bittubadri]

Cell D2 generates either of a numerical value or null or space/(s).
E2=IF(D2=null OR space/(s),0,the numerical value)

How to accomplish?

[Paul]

Perhaps...

Please Login or Register  to view this content.

To account for multiple spaces, you could also try:

Please Login or Register  to view this content.

[bittubadri]

Paul May I know what is the difference between the 2 formulas? Rather which one is more useful?

[Paul]

The first formula only checks for Null or one space character in D2. If either is the case, 0 is returned, otherwise the value in D2 is returned.

The second formula TRIM's the value in D2 (removing any leading or trailing spaces) first. If D2 was already empty, or had 1+ spaces, it will be seen as empty and the formula will show 0, otherwise it will show the value in D2.

[bittubadri]

Thanks Paul for sharing the knowledge. I have used your first formula.