Quote:
Originally Posted by Waa
I am new at excel and curious... please help.
The following formulea is used in our purchase orders -- what does it mean?
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")
|
It means, if the value in cell I39 is greater than zero, multiply the value in I39 by the value in I40 and add to that the value in I39. If I39 is zero, do nothing.