Equal "" when zero has a space after it
In , T. Valko
spake thusly:
Let's see if this is what you want:
If A1 = 0 *or* "0 " then return blank ("") otherwise return A1.
If that's what you want:
=IF(OR(A1=0,A1="0 "),"",A1)
I'm left wondering if the OP has a space merely because he
wants it there for nice formatting purposes. If that is the
case, I'd suggest to him to remove the space and use formatting
options to put "space" there instead. E.g., format as type
"Accounting" is one easy way to get there.)
--
dman
|