Prev: Excel basic quiz
Next: =COUNTIF(B2:B4,"w")&" wins, "&COUNTIF(B2:B4,"l")&"
From: Luke M on 15 Jan 2010 09:26
=If(A1>0,1,"")

Copy down as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Trace" wrote:

> How do I get a return of 1 in column B for all numbers in column A that are
> greater than 0?
 | 
Pages: 1
Prev: Excel basic quiz
Next: =COUNTIF(B2:B4,"w")&" wins, "&COUNTIF(B2:B4,"l")&"