comparing data

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

In A1, I have a value, and in A2 I have another value. Now what I want, is
to calculate the difference. If the value of cell A2 is equal to or greater
than that of A1, then I want a "1" to be put into A3. If A2 is less than A1,
then I want a "0" to be put in A3.

Thanks in advance
 
Hi

This should do it for you - type this formula into A3
=if(A2>=A1,1,0)

Hope this helps

Cheers
JulieD
 
Back
Top