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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
