| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding down from .9 in an IF stmt
I am working on a project, if a score is anywhere between 69.5 to 69.999999,
I need it to round down to 69, not round up to 70. This is the formula I have in under Grade % =IF(E70="","",(E70/C70)*100) The correct answer is 69.6, but for this particular course, if the student scores anything below a true 70% they must retake the test. So, I need it to round anything below a true 70 down to 69. Number of Number Number Grade Questions Wrong Correct % 50 15.20 34.80 70 Thank you for your input. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding down from .9 in an IF stmt
Try using FLOOR or ROUNDDOWN, e.g. =IF(E70="","",FLOOR(E70/C70*100,1)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=567668 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| Financial Stmt rounding issues | Excel Worksheet Functions | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Linear Mode
