If Then Function Help

[ugzruben]

I need help coming up with a function.

Please see jpg.

The Value 2 is the qualifier
and Value 1 has a set of numbers
The CONFIRM column is where I need the formulation.

What I am trying to come up with is a formula that states the following.

If A4 is less than or equal to B12 then -1.
If A4 is greater than B12 then 0

Thank you.

The second jpg is what I want to cells to look like after adding the formula.

\1

\1

[martindwilson]

=if(a4<=b12,-1,0)

[ugzruben]

Thank you!!!

[sglife]

Here are 3 formulas for you.

Please Login or Register  to view this content.