View original (French)

Round up to the nearest 0.5 in a formula + condition

Solved
MCoC Posted messages 9 Registration date   Status Member Last intervention   -  
Vaucluse Posted messages 27336 Registration date   Status Contributor 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

2 answers

  1.
    f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
     
    Hello,

    for the upper rounding:

    =CEILING(BV5+BW5;0)/2
    1