=IF(E2="Open",U2,IF(E2="Closed",IF(S2="",T2,""),"" )

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"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?