IF

[hsandeep]

In SO2=IF(RN2=FALSE,0,MAX(SK2,SL2,AX2))

But I want the formula to check...
If RV2=100, then also MAX(SK2,SL2,AX2) else 0

How to accomplish

 

[gaz_chops]

Maybe

=IF(or(RN2=FALSE,RV2<>100),0,MAX(SK2,SL2,AX2))

 

[hsandeep]

Maybe

=IF(or(RN2=FALSE,RV2<>100),0,MAX(SK2,SL2,AX2))

Thanks gaz_chops for replying.

This is not the required one..
The statement goes like: If RN2=FALSE then 0 BUT IF RV2=100(even RN2=FALSE) then MAX(SK2,SL2,AX2) else MAX(SK2,SL2,AX2)

 

[Aladin Akyurek]

In SO2=IF(RN2=FALSE,0,MAX(SK2,SL2,AX2))

But I want the formula to check...
If RV2=100, then also MAX(SK2,SL2,AX2) else 0

How to accomplish

Try...

=IF(OR(RN2,RV2=100),MAX(SK2,SL2,AX2),0)

 

[gaz_chops]

Then
=IF(AND(RN2=FALSE,RV2<>100),0,MAX(SK2,SL2,AX2))

 

[hsandeep]

try...

=if(or(rn2,rv2=100),max(sk2,sl2,ax2),0)

yes that works.

 

[hsandeep]

Try...

=IF(OR(RN2,RV2=100),MAX(SK2,SL2,AX2),0)

I tried a 'similar' change in another cell but could not do?

The formula was: =IF(ACR2=FALSE,0,IF(ADI2=0,AT2,MIN(ADI2,AT2)))

I changed the formula to: =IF(OR(ACR2,ADQ2=100),IF(ADI2=0,AT2,MIN(ADI2,AT2))) to include BUT IF ADQ2=100.... but the answer is FALSE.

 

[hsandeep]

Try...

=IF(OR(RN2,RV2=100),MAX(SK2,SL2,AX2),0)

Please tell: What is the meaning of OR(RN2,....

i.e. formula checks for RN2=FALSE or TRUE?

 

[Aladin Akyurek]

I tried a 'similar' change in another cell but could not do?

The formula was: =IF(ACR2=FALSE,0,IF(ADI2=0,AT2,MIN(ADI2,AT2)))

I changed the formula to: =IF(OR(ACR2,ADQ2=100),IF(ADI2=0,AT2,MIN(ADI2,AT2))) to include BUT IF ADQ2=100.... but the answer is FALSE.

Your intend here is not clear...

Please tell: What is the meaning of OR(RN2,....

i.e. formula checks for RN2=FALSE or TRUE?

In

IF(OR(RN2,RV2=100),MAX(SK2,SL2,AX2),0)

OR checks whether either RN2 (i.e., RN2=TRUE) or RV2=100. When one of these checks are TRUE, IF proceeds to MAX, otherwise IF gives 0.