RE: function

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sure, that's exactly what that formula does.

If the first condition fails (the grade isn't 60 or above... a.k.a. "greater
than or equal to"), the only other option is for the grade to be strictly
less than 60, so you don't need a check for it. That is the default
condition.
--
Regards,
Dave


"stacy" wrote:

> Thanks...but if the grade is below 60, I need the grade to be 60.....
>
> "David Billigmeier" wrote:
>
> > In C5:
> > =IF(B5>=60,B5+5,60)
> >
> > --
> > Regards,
> > Dave
> >
> >
> > "stacy" wrote:
> >
> > > I need a formula that does the following:
> > >
> > > A student's grade on a test is in cell B5. Write a formula in cell C5 to
> > > curve that grade. IF the grade is 60 or greater, add 5 points to the grade.
> > > If the grade is below 60, make the grade 60.
.

Relevant Pages