Sum Function

New Contributor

Hello, I am looking for a function similar to D=((A*B)+C), but I need "D" Value to be 0 only when "A" is 0. It will still say D=C now if "A" is 0. I Want to add "C" only if (A*D)>0 or 1.

5 Replies

@Lyles1926 Something like this?

Screenshot 2022-09-02 at 21.23.00.png

best response confirmed by Lyles1926 (New Contributor)

@Riny_van_Eekelen  actually i think they want:




@mtarler Could be. Not sure though.

Close, but this got me what I needed. I say close because I need D2 To equal 0 If the value for A2 is 0.
Thanks @Riny_van_Eekelen


Just in case, another notation

=( A2*B2+C2 ) * (A2<>0)