Hi All,

I'm relatively new to the formula functions of Excel (this is my first post) so I was hoping someone with more experienced may be able to help me!

I'm trying to create a formula that says:

IF cell N1 contains the string of text "Invoice" then cell U1 should equal cell F1. OR if If cell N1 contains the string of text "accrual" AND cell F1 is less than 0, then cell U1 should equal cell F1. Otherwise return nothing ("").

The formula I currently have is:

=IF(ISNUMBER(SEARCH("Invoice",$N1)),F1,""). However, I can't quite figure how to code the formula for the second part I wish to add (OR if If cell N1 contains the string of text "accrual" AND cell F1 is less than 0, then cell U1 should equal cell F1).

Any help would be much appreciated.

TOLJ