CAN I INSER CONDITIONAL

Closed
IZZY - Dec 30, 2009 at 01:27 PM
venkat1926 Posts 1863 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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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