Excel formula
 

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 ?

Excel formula
 

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

"DamienO" wrote:

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 ?

Excel formula
 

Thanks bj

"DamienO" wrote:

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 ?