| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
function
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
|
#5
|
|||
|
|||
|
Thank you so much....it did work ;-)
"David Billigmeier" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Date & Time | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Hybrid Mode
