Excel, if value > 0, assign to 1, if not, assign to 0

Question

I have a huge spreadsheet with a bunch of columns. For one of the columns, labelled "Clicks," it displays the number of clicks a person has made on a particular email. One person can click 0 or more times. I only care if there has been a click, but not how many. So, I'd like the values to be either 0 or 1.

I tried the following formula, without success (it gives me an error: Clicks must be whole number from -21...... through 21.......).

=IF(AND(H2>0), 1)

Answer 1

This should work for you:

=IF(H2>0, 1, 0)

Basically, the first parameter is the condition, the second parameter is what will be displayed if that condition is TRUE, the third parameter is what will be displayed if the condition is FALSE.

Answer 2

Can be achieved with a Custom format:

[>0]1;0

Answer 3

Use MIN, to return 0 or 1:

=MIN(H2,1)