Forum Discussion
Using a Sum function within a IF function
Hello, I have possibly a simple question. I have developed a =IF that contains a SUM function. when I attempt to copy it down my spreadsheet, the cells in the SUM statement become absolute I would ...
Entered your formula in a new workbook and copied it down a few rows. None of the cell references became absolute for me. Perhaps you can upload your workbook to demonstrate the problem.
By the way, you may want to make your formula a bit easier to read and maintain. The SUM statement is not needed and it will reduce the number of brackets. I think this one will achieve the same result (with row 1 as the base in stead of 65 in your example);
=IF(E1*G1<0,ABS(G3*100)*ABS(E3)+100*M3*K3+100*Q3*O3+100*U3*S3+100*Y3*W3,"ea")