SOLVED

Sum Function

Copper 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 (Copper Contributor)
Solution

@Riny_van_Eekelen  actually i think they want:

=IF(A2,A2*B2+C2,0)

or

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

@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.
=IF(A2,A2*B2+C2,A2)
Thanks @Riny_van_Eekelen

@Lyles1926 

Just in case, another notation

=( A2*B2+C2 ) * (A2<>0)
1 best response

Accepted Solutions
best response confirmed by Lyles1926 (Copper Contributor)
Solution

@Riny_van_Eekelen  actually i think they want:

=IF(A2,A2*B2+C2,0)

or

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

View solution in original post