ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If (https://www.excelbanter.com/excel-worksheet-functions/253548-if.html)

Trace

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

Luke M

=If(A10,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?

Eduardo

Hi,

=if(A10,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?

All times are GMT +1. The time now is 12:47 PM.