IF Statement

[MrsVodes3965]

=IF(G4=0, IF(C4=0, "None","Review MC"),IF(C4=0, "Review MD claim", IF(C4=G4,"Let system price","Follow"))) works but now I need to add another IF or 2

IF column D = $0.00 and column H = $0.00 then "deny" otherwise complete the above formula. I got it to work partially but it puts in deny when columns D and H are blank(empty field) which is not correct. If blank it should do the above formula. I am in need of a nested IF

If D&H condition is met then "Deny", If D&H are blank or more than $0.00 then do top formula.

 

[aghaffar82]

=IF(AND(D4=0,H4=0),"Deny",IF(G4=0, IF(C4=0, "None","Review MC"),IF(C4=0, "Review MD claim", IF(C4=G4,"Let system price","Follow"))))

I'm not sure what is the purpose of "IF(G4=0" is in your formula?

 

[MrsVodes3965]

The formula does not work ... #name? is the results of the above

 

[aghaffar82]

Strange, very same formula is working for me perfectly fine.
=IF(AND(D4=0,H4=0),"Deny",IF(G4=0, IF(C4=0, "None","Review MC"),IF(C4=0, "Review MD claim", IF(C4=G4,"Let system price","Follow"))))

 

[MrsVodes3965]