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...
The easiest way is simply to put SUM() around your cell references:
=IF(SUM(D1)-SUM(C1)<0,"",SUM(D1)-SUM(C1))
Dan Elgaard Whyever would you want to wrap each cell reference into a SUM function? this accomplishes absolutely nothing and the result is exactly the same as with the formula in the initial question. By all means, use Sum() if you want to create a sum of something, or use Sum() to create some hot formula tricks, but don't use it if it does not add value. That just increases the calculation load for Excel.