Conditional Formula: Using 'If' 'And' and 'Or' - solution will save days of work!

[RLBrown]

Goal:

IF
Column E is Blank
AND
Column M
OR
Column T are <0

True= "Review" False= Blank

I can write the 'if/and' but when I include the 'or' my results are meaningless.

Any help appreciated, as a solution will save me days of work.

 

[mumps]

Try:
=IF(AND(E1="",OR(M1<0,T1<0)),"Review","")

 

[DanteAmor]

How about without OR

=IF(AND(E2="",MIN(M2,T2)<0),"Review","")

 

[RLBrown]

This statement =IF(AND(E1="",OR(M1<0,T1<0)),"Review","") from mumps worked so beautifully for my situation.
(Dante I saved your for future need/application!!)

A sincere 'Thank You to both of you for saving me hours of work! I will pay your help forward within this forum when I am able

 

[mumps]

Glad we could help. No need for payment.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.
With thanks is enough.