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

1509 views excel
-1

enter image description hereI 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)

answered question

1 Answer

5

Use MIN, to return 0 or 1:

=MIN(H2,1)

posted this

Have an answer?

JD

Please login first before posting an answer.