B1 = x, C1 = 0
I want to write a formula in D1 that IF B1 is Less than Zero then Value of C1 should get change to "1" & if B1 is greater than Zero then C1 should get change to "2"
You could write a formula in C1 which will produce the required result
C1=(B1 > 0)*1 + (B1 < 0) * 2
This formula wil alsol produce the result 0 if B1 = 0.
