Help with Nested IFOR syntax

[Helen842000]

Hi all,

I have the following statement that is returning #Value.

Can anyone help me with the syntax please?

=IF(Detail!E4<>"", "FILLED",IF(Summary!C4<>""+Detail!E4="",EMPTY,""))

So it should be

If E4(detail tab) contains any text print FILLED, ELSE if both C4(summary tab) and E4(detail tab) are empty print EMPTY else stay blank.

Thanks!

 

[VoG]

Is it

=IF(Detail!E4<>"", "FILLED",IF(AND(Summary!C4<>"",Detail!E4=""),"EMPTY",""))

 

[Helen842000]

Is it

=IF(Detail!E4<>"", "FILLED",IF(AND(Summary!C4<>"",Detail!E4=""),"EMPTY",""))

Yes! It is! Amazing, thank you!