CAN I INSER CONDITIONAL

Closed

IZZY - 30 Dec 2009 à 13:27
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 30 Dec 2009 à 23:28

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
Excel conditional formatting based on date - Guide
Conditional formatting between two values ✓ - Excel Forum
Conditional formatting if cell contains text ✓ - Excel Forum
Inser key - Guide
Excel conditional formula multiple conditions ✓ - Excel Forum

1 response

Réponse 1 / 1

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
30 Dec 2009 à 23:28

=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?

Conditional Format Cells Based on Another Cell and Own Cell

Conditional formatting based text in another cell

Conditional Formatting - highlight overdue dates

Similar discussions

Subscribe To Our Newsletter!