CAN I INSER CONDITIONAL

Closed
IZZY - Dec 30, 2009 at 01:27 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Dec 30, 2009 at 11:28 PM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Dec 30, 2009 at 11:28 PM
=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))
0