IF AND STATEMENT

[thewiseguy]

Hi all - I'm having a tough time with this one. Currently I am using this formula:

=IF(D4="control",'Project Items '!$E$22,'Project Items '!$E$10)

I want to add the following AND statement:

=IF(O4<>"",'Project Items '!$E$10,"")

Can someone help combine these?

 

[etaf]

=IF(D4="control",'Project Items '!$E$22,'Project Items '!$E$10)
to
=IF(D4="control",'Project Items '!$E$22, IF(O4<>"",'Project Items '!$E$10,""))

 

[thewiseguy]

=IF(D4="control",'Project Items '!$E$22,'Project Items '!$E$10)
to
=IF(D4="control",'Project Items '!$E$22, IF(O4<>"",'Project Items '!$E$10,""))

many thanks!

 

[etaf]

you are welcome