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