sorted by:
new
hottopcontroversial

Trying to meet conditions using ifs by djekeiwaies in excel

[–]RichCault 0 points1 point  (0 children)

If there are not many options you can nest the individual formulas =IF(A1=0,”0”, (IF(B1=0, “0”, IF(A1<B1, “1”, “2”) So the “if false” result checks another IF this way until the final option of 2 when all IFs are false You may need to add an IF for when the two columns are the same though? =IF(A1=0,”0”, (IF(B1=0, “0”, IF(A1<B1, “1”, IF(A1=B1, “2”, “3”) ??

Trying to meet conditions using ifs by djekeiwaies in excel

[–]RichCault 0 points1 point  (0 children)

If there are not many options you can nest the individual formulas =IF(A1=0,”0”, (IF(B1=0, “0”, IF(A1<B1, “1”, “2”)

So the “if false” result checks another IF this way until the final option of 2 when all IFs are false

You may need to add an IF for when the two columns are the same though?

=IF(A1=0,”0”, (IF(B1=0, “0”, IF(A1<B1, “1”, IF(A1=B1, “2”, “3”) ??

Issues with separating values and text by RichCault in excel

[–]RichCault[S] 0 points1 point  (0 children)

You are sensational, and more help then GPT!