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