What happens if the entries are not exactly as you specified? I have the
formula returning "Your Data is not correct"

=IF(TRIM(E2)="Open","",IF(AND(TRIM(E2)="Closed",TR IM(S2)=""),T2,IF(AND(TRIM(E2)="Closed",S2<""),"", "Your
Data is not correct")))

The TRIM() function are to take care of any spaces that you previously
reported in your data

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Secret Squirrel" wrote in
message ...
I'm trying to work an IF statement with these conditions:

If E2 = "Open" then U2
If E2 = "Closed" & S2 = "" then T2, and if E2 = "Closed" and S2 is not
blank
then ""

I've tried this a few different ways but haven't been able to come up with
my solution. Can anyone help me write this?