From: Eduardo on
Hi,

=if(A1>0,1,"")

"Trace" wrote:

> How do I get a return of 1 in column B for all numbers in column A that are
> greater than 0?