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...
Thank you!! Im going to give this a try. If I may, Id like to ask exactly what this formula is saying, and what is the purpose of the =if(and(Count(C1:D1)=2,D1-C1>0),D1-C1,"") part of the formula? I want to fully understand what the language is, rather than lean on everyone. Your help is greatly appreciated!
Hello,
the Count() function counts the cells that have numbers (not text). So, in this formula, if the Count() of cells C1 to D1 returns the result 2, that means that both of these cells contain a number. Used in an IF() statement, Count is a great way to ensure that a calculation is only performed when all required input cells have been filled in.