IF and AND functions in LibreOffice
margauxgardet
Posted messages
2
Status
Membre
-
Virginie -
Virginie -
Hello,
I have a table created in LibreOffice that represents students' grades for different subjects, as well as their overall averages.
I need to create a column using the IF and AND functions so that:
Passed: IF the overall average is greater than or equal to a constant a AND IF each grade is greater than or equal to a constant b
Failed: otherwise
For example, I've tried different configurations of the formula, but nothing works...
I have something like this:
=IF((F14>=J14)AND(B14:E14>=J15); passed; failed)
But it doesn't work... I think the AND is misplaced...
Thank you in advance for your help!
Have a good day!
Configuration: Windows 7 / Chrome 38.0.2125.104
I have a table created in LibreOffice that represents students' grades for different subjects, as well as their overall averages.
I need to create a column using the IF and AND functions so that:
Passed: IF the overall average is greater than or equal to a constant a AND IF each grade is greater than or equal to a constant b
Failed: otherwise
For example, I've tried different configurations of the formula, but nothing works...
I have something like this:
=IF((F14>=J14)AND(B14:E14>=J15); passed; failed)
But it doesn't work... I think the AND is misplaced...
Thank you in advance for your help!
Have a good day!
Configuration: Windows 7 / Chrome 38.0.2125.104
Thank you very much, your formula has helped me a lot.