Round up to the nearest 0.5 in a formula + condition
Solved
MCoC
Posted messages
9
Registration date
Status
Membre
Last intervention
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
I am preparing a large spreadsheet for the mailing of report cards. I found several formulas/methods on the site, but the problem is that my grade is already determined by an average formula (for example: =(BV5+BW5)/2). So, how and where should I add the rounding formula?
Finally, I also have a column for ADMITTED/ADMITTED or REFUSED/REFUSED that contains a formula with conditions (if such a grade, student admitted or refused). But I would also like the formula to agree with the gender.
Example: If Ms. XX scores 11, she is admitted, and not admitted.
So I am unsure how to nest all my formulas without breaking anything. And since these are report cards, I cannot afford to make mistakes; imagine the students' reaction...
Thank you in advance!
Configuration: Windows 7 / Chrome 39.0.2171.95
I am preparing a large spreadsheet for the mailing of report cards. I found several formulas/methods on the site, but the problem is that my grade is already determined by an average formula (for example: =(BV5+BW5)/2). So, how and where should I add the rounding formula?
Finally, I also have a column for ADMITTED/ADMITTED or REFUSED/REFUSED that contains a formula with conditions (if such a grade, student admitted or refused). But I would also like the formula to agree with the gender.
Example: If Ms. XX scores 11, she is admitted, and not admitted.
So I am unsure how to nest all my formulas without breaking anything. And since these are report cards, I cannot afford to make mistakes; imagine the students' reaction...
Thank you in advance!
Configuration: Windows 7 / Chrome 39.0.2171.95
