Urgent required help

[yashgandhi]

=IF(OR(D19="ECA to Native Processing and Review DB Upload",G19="02 Pending PM Review",G19="03 Approved by PM"),ISBLANK(K19),IF(OR(D19="ECA to Native Processing and Review DB Upload",G19="02 Pending PM Review",G19="03 Approved by PM"),ISBLANK(L19),IF(OR(D19="ECA to Native Processing and Review DB Upload",G19="02 Pending PM Review",G19="03 Approved by PM"),ISBLANK(O19),IF(OR(D19="ECA to Native Processing and Review DB Upload",G19="02 Pending PM Review",G19="03 Approved by PM"),ISBLANK(P19)))))




IF D19, G19, SATISFIES THE CONDITION AND IF THERE IS NO DATA THEN IT SHOULD RETURN BLANK IN K19, L19, O19,P19 OTHERWISE DATA IS THERE SHOULD COME


[TABLE="width: 1841"]
<colgroup><col><col span="26"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

Its not possible for a formula to return a blank in 4 different cells if thats what you ask. You also misunderstand ISBLANK. ISBLANK tests if a cell is blank and returns TRUE or FALSE. It doesnt return a blank.