View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default 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.