IF & AND Functions error

[Johnpow]

Hello all,

Can someone correct the below formula please?

Message I get is The formula you typed contains and error.

 =IF(AND($P$6="F1",=IF(T15>$AH$13,$AJ$12,IF(AND($P$6="F1",IF(T15>$AF$13,$AH$12,IF(AND($P$6="F1",IF(T15=$AL$12,"",$AF$12)))

Maybe I need different functions?

 

[VBABEGINER]

Hi, Im just giving you example how should it return, IF with AND

=If(Logical test,if condition is true then your 1st answer here,if condition is not true then your 2nd answer here)

=AND(Cell Reference i.e. P6 = "Value 1", P6 = "Value 2")

Place this AND in IF formula, Logical test area.. Like,
=If(AND(Cell Reference i.e. P6 = "Value 1", P6 = "Value 2"),if condition is true then your 1st answer here,if condition is not true then your 2nd answer here)

 

[Finalfight40]

Hi John

What is it you are trying to do?

 

[ClaireS]

Take the "=" out after the first comma - you are introducing a second IF function, but you have presumably copied and pasted it from another formula and you don't need the leading "=".

 

[Johnpow]

Trying to rate players in a footy team using a KPI points system. Fairly complicated.
I have a workbook to illustrate but cannot load to the forum.
Suggestions how I can provide the Wbook please

 

[Johnpow]

Thanks Claire. my mistake, I did remove the 2nd "=" still formula does not work.

 

[VBABEGINER]

Hi John, i think you're trying this..

=IF(AND($P$6="F1",T15>$AH$13),$AJ$12,IF(AND($P$6="F1",T15>$AF$13),$AH$12,IF(AND($P$6="F1",T15=$AL$12),"",$AF$12)))

 

[Johnpow]

Have loaded a workbook on Google drive

https://drive.google.com/file/d/1G5pjKDn8FY_k0xhgGUonLMNITCtkw-Z0/view?usp=sharing

 

[Johnpow]

Have loaded a workbook on Google drive

https://drive.google.com/file/d/1G5p...ew?usp=sharing

 

[ClaireS]

I can't see how the Google Sheet relates to your question. Have you tried VBABEGINER's formula? I don't think I'm going to be able to help here. Good luck!