Forum Discussion

Hopgrower's avatar
Hopgrower
Copper Contributor
Oct 26, 2019

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 ...
=IF function copying problems
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 28, 2019

Hopgrower 

I guess your formula could be simplified to

=IF(E65*G65<0,100*(ABS(G67*E67)+M67*K67+Q67*O67+U67*S67+Y67*W67),"ea")

if copy/paste one row down it will be as

=IF(E66*G66<0,100*(ABS(G68*E68)+M68*K68+Q68*O68+U68*S68+Y68*W68),"ea")

if that's what do you mean. Your initial formula with SUM shall return exactly the same result.

Resources