Hi, I'm very new to Excel and need some help (with a maybe very basic function).
I need to create a system that choose between two parameters to round up or down the number depending on a condition. This is for scoring students with a decimal system, so I need to round the final score.
What I exactly need is this: if the score is between x,01 and x,24 round down to x / if the score is between x,25 and x,49 round up to x,5 / if the score is between x,51 and x,74 round down to x,5 / if the score is between x,75 and x,99 round up to x
For example: if the score is between 7,01 and 7,24 round down to 7,0 / if the score is between 8,25 and 8,49 round up to 8,5, and so on.
I need to create a system that choose between two parameters to round up or down the number depending on a condition. This is for scoring students with a decimal system, so I need to round the final score.
What I exactly need is this: if the score is between x,01 and x,24 round down to x / if the score is between x,25 and x,49 round up to x,5 / if the score is between x,51 and x,74 round down to x,5 / if the score is between x,75 and x,99 round up to x
For example: if the score is between 7,01 and 7,24 round down to 7,0 / if the score is between 8,25 and 8,49 round up to 8,5, and so on.
