if value in Column C is less than value in Column K then value in Column E is negative,

[wbs_1176]

if value in Column C is less than value in Column K then value in Column E is negative, if value in Column C is more than value in Column K then value in Column E is positive

[#2]

This is how the formula will be
=IF(C2<K2,"Negative","Positive")

Click Enter and copy the formula down using fill handle

[#3]

Hello @wbs_1176 

The first proposed formula works if you want to return a text value "positive","negative".

However, if you want to determine whether a numeric value is positive or negative I suggest a similar but different approach.

Do your formula in a new column and return either -1 or 1.

=IF(C2<K2,-1,1)

Then you can multiply Column E x Column L.

• If Column E is already getting its value from a formula just add *L2 (ex.   E2 =  Sum(M2:P2)*L2
• If Column E is a static value, use a new column M (could be any column you want)  M2 = E2*L2

Example Output:

   C       E         K          L       M       

  12    100       15       -1       -100

  20    100       11        1        100

In this formula, keep in mind, being equal will also default to positive.

Is this what you are trying to accomplish?

[#4]

@wbs_1176 

As variant

=SIGN(C2-K2)*ABS(E2)