Adjusting a formula to add another function

[cheech1206]

Hi Ya'll,
I just need some help adding another function to and existing formula.

=IF(L6="","",IF(L6="Prof",60,IF(F6="M",INDEX('Run Times'!A3:K905,MATCH(L6,'Run Times'!A3:A905,0),MATCH(G6,'Run Times'!A3:K3,1)),IF(F6="F",INDEX('Run Times'!L3:V905,MATCH(L6,'Run Times'!L3:L905,0),MATCH(G6,'Run Times'!L3:V3,1)),""))))

The formula above also need to include that if L6 has the text NG it needs to have a value of 0 but if it has a text of GO it needs to have a value of 60. I also attached the spreed sheet below. The column L that is labeled "2m Raw Score" needs to also be able to have the text NG which would equal 0 points or GO that would equal 60 in column O labled "2m points". I really appreciate any help.

no names APFT and Weapons.xlsx

[kassieK]

=IF(L6="","",IF(L6="NG",0,IF(L6="GO",60,IF(L6="Prof",60,IF(F6="M",INDEX('Run Times'!A3:K905,MATCH(L6,'Run Times'!A3:A905,0),MATCH(G6,'Run Times'!A3:K3,1)),IF(F6="F",INDEX('Run Times'!L3:V905,MATCH(L6,'Run Times'!L3:L905,0),MATCH(G6,'Run Times'!L3:V3,1)),"")))))).

I think you tried to add it on at the end, hence an #N/A error. Putting it in front will result in an answer, because F6 may very well contain an "M" or an "F", resulting in a TRUE answer, but then it cannot match & index L6.

[vlady]

just shorter i think..?

=IF(L6="","",IF(L6="NG",0,IF(or(L6={"GO","Prof"}),60,IF(F6="M"....
and maybe combine the first if statement
=IF(or(L6={"","NG"}),0
the result would be...
=IF(or(L6={"","NG"}),0,IF(or(L6={"GO","Prof"}),60,IF(F6="M"....

[cheech1206]

Thank yall so much. I cant believe that I missed something as simple as that. Thanks again.

[vlady]

your very much welcome, from me and kassieK and of course the forum..