Determining if a number is above or below another number

502 Views Asked by At

I want to know if there is a way, using Excel or a similar program, because I have a bit too many numbers to do it by hand, to determin if any given number $x$ is above or below a set number $b$.

Is $x>b$ or $x<b$?

So given a set number 10 I want a fast way to check if a number 15 is above or below 10. Here the result is above.

1

There are 1 best solutions below

0
On

To test if cell A1 is bigger than $10$, type

=IF(A1>10,1,0)

return $1$ if greater than $10$, otherwise $0$.