Previous Topic Next Topic

CAN I INSER CONDITIONAL

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 -
Hello,
i'M TRYING TO INSERT IF CONDITIONAL TO AN EXISTING FORMULA.

CAN i DO ..... =SUM(A2*3)-(d4)*6=if(d6<=0,"0")

I'm entering this formula in cell d4

thank you

1 reply

Answer 1 / 1
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 803
=SUM(A2*3)-(d4)*6=if(d6<=0,"0")

your requirement is not clear

do you mean this

=if(d6<=0,0,(A2*3)-(D4*6))
Ask a question