Forum Discussion
How do you write a formula that must have two conditions met?
Making progress, thanks to the help of the kind people here! I Have this formula: =IF(D1-C1<0,"",D1-C1) I'm REALLY proud of myself here, at this point! It worked properly. However, when both C a...
Both empty:
=IF(AND(D1="";F1="");"";IF(D1-C1<0,"",D1-C1))
At least 1 empty (and obviously also both):
=IF(OR(D1="";F1="");"";IF(D1-C1<0,"",D1-C1))