Advertisement
mayankjoin3

excel octact formula

Sep 9th, 2022
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. =IF(AND(H2>=0,I2>=0,J2>=0),"+1",IF(AND(H2>=0,I2>=0,J2<0),"-1",IF(AND(H2<0,I2>=0,J2>0),"+2",IF(AND(H2<0,I2>=0,J2<0),"-2",IF(AND(H2<0,I2<0,J2>0),"+3",IF(AND(H2<0,I2<0,J2<0),"-3",IF(AND(H2>=0,I2<0,J2>0),"+4",IF(AND(H2>=0,I2<0,J2<0),"-4"))))))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement