Return value if cell greater then 0
I take it you didn't like my answer in the other newsgroup.
If you mean you want the formula in Column A, Check Column B and have the
answer in Column C:
not possible without programming. Formulas give a result in the cell they
are in, not anywhere else (fortunately!)
If this is not what you mean, please spend a few words explaining what
you're trying to achieve.
--
Kind regards,
Niek Otten
"Dave Semple" wrote in message
...
for a column of numbers greater then 0 (zero) divide by .8 and return
value
to another column.
|