Return value if cell greater then 0
It helps if you state your question clearly.
Assuming your value is in A1, I think you want something like this
=if(A10,A1/.8,something else A1<=0)
"Dave Semple" wrote:
for a column of numbers greater then 0 (zero) divide by .8 and return value
to another column.
|