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

CAN I INSER CONDITIONAL
Conditional hyperlink excel ✓ - Excel Forum
Conditional formatting based on date ✓ - Excel Forum
Copy conditional formatting to other cells ✓ - Excel Forum
Openoffice conditional formatting - Guide
Conditional formatting and IF statements ✓ - Office Software Forum

1 response

Answer 1 / 1

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))

Similar discussions

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Formula for conditional format to color cells

Please unban my WhatsApp

Conditional Formatting: 3 range of numbers

Similar discussions

Subscribe To Our Newsletter!