Excel formula

[Guest]

Hi,
I'm trying to return a string if either of 2 conditions are present in the
same cells.
I'm trying to run with
=IF(AND(R$2=6,$A5="Weekly"),"Report",IF(AND
R4=TRUE,N5="Monthly"),"Report",""))
What I want is if R2=6 and A5=weekly to return Report
OR
if R4=True and N5=Monthly to return Report ......otherwise remain blank.
Any ideas ?

 

[Guest]

=if(or(and(R$2=6,$A5="Weekly"),AND (R4=TRUE,N5="Monthly")),"Report","")

 

[mdschuetz]

The AND function only returns TRUE when all its arguments are TRUE.


The OR function returns TRUE when ANY argument is TRUE.

 

[Guest]

Thanks bj