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 like them to adjust to the new corresponding cells as I copy down. What do I do. Here is the Function =IF(E65*G65<0,SUM((((ABS(G67*100)*ABS(E67))))+(((100*M67)*K67)+((100*Q67)*O67)+((100*U67*S67))+((100*Y67)*W67))),"ea") The E65*G65 adjust accordingly during the copy and paste the rest do not. Thankyou