=IF(A10,1,"").
--
Regards,
Peo Sjoblom
(No private emails please)
"geza" wrote in message
...
Hi everyone,
I use quite often a simple formula when I want to populate a helper column
(used as a counter) every time I enter an alpha value in the adjacent cell
such as:
B1=IF(A1="Y",1,0).
How would I accomplish the same result when, instead of the alpha values
of
Y or N, I have a dollar amount. In other words, every time I enter a
dollar
value zero, a "1" will be populated in the adjacent cell; when there is
a
zero amount (such as $0.00), the adjacent cell will be left blank.
Thank you,
Geza.
|