Google Sheet IF + Filter

user19998204 0
Viewed 25

So I have this raw data which I need to filter the score of the user based on specific dates

=IFERROR(FILTER(Raw!$AF:$AF, Raw!$AG:$AG=$C2, Raw!$AH:$AH=I$1),"0.00")

Raw!$AF:$AF = Score 
Raw!$AG:$AG = Username
Raw!$AH:$AH = Date

If error the result will be 0.00, but if the value is >8 it should display 8.00 only.

So if Raw!$AF:$AF = 8.95 it should display 8.00 only. I am having trouble doing that, already tried insterting IF inside the filter then >8,8 but it won't work

google-sheets
1 Answers

You can use plain IF:

=IFERROR(FILTER(IF(Raw!$AF:$AF>8,8,Raw!$AF:$AF), Raw!$AG:$AG=$C2, Raw!$AH:$AH=I$1),"0.00")

Or MIN:

=MIN(IFERROR(FILTER(Raw!$AF:$AF, Raw!$AG:$AG=$C2, Raw!$AH:$AH=I$1),"0.00"),8)
TheMaster0
Related