This bugger doesn't work

[apurk45]

Hi
Can any of you tell what is wrong with my formula?

=IF(AND(K8>0,M8="IJK",MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F8)),G8,IF(MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F9),G9,IF(MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F10),G10,"")))

My cell K8=0 and for ungodly reason my formula does not recognize it.
Also if you have any suggestion how to make this formula shorter would be appreciated.

Thanks
Apurk45

 

[apurk45]

Hi again

I thought that I had this one:

=IF(AND(K8>0,OR(M8="IJK","Edge","SurfRad"),MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F8)),G8,IF(AND(K8>0,MAX(ABS(F8),ABS(F9),ABS(F172))=ABS(F9)),G9,IF(AND(K8>0,MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F10)),G10,"")))

BUT I had to add the bolded portion of my formula and now I am getting
#VALUE error.
My formula is in cell H9

Could you please see what I did wrong this time.
Before I made the change - worked just fine.

Apurk45

 

[NateO]

Try the following:

=IF((K8>0)*(SUM(--(M8={"IJK","Edge","SurfRad"}))),TRUE,FALSE)

 

[Ahnold]

The "OR" function needs to look like this
=IF(AND(K8>0, OR(M8="IJK",M8="Edge",M8="SurfRad" ),MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F8)),G8,IF(AND(K8>0,MAX(ABS(F8),ABS(F9),ABS(F172))=ABS(F9)),G9,IF(AND(K8>0,MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F10)),G10,"")))
or this
=IF(AND(K8>0, OR(M8={"IJK","Edge","SurfRad"}),MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F8)),G8,IF(AND(K8>0,MAX(ABS(F8),ABS(F9),ABS(F172))=ABS(F9)),G9,IF(AND(K8>0,MAX(ABS(F8),ABS(F9),ABS(F10))=ABS(F10)),G10,"")))

 

[apurk45]

Hi

Sorry for such a late respond.

Formula works great.

Big THANK YOU for all of you for your help and patient.

Apurk45

PS
How do you add "Solved" to the Message Subject Line ????

 

[NateO]

PS
How do you add "Solved" to the Message Subject Line ????

You don't.