| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
How about:
=ROUND(A3/0.00125,0)*0.00125 =ROUND(A3/(0.01/8),0)*(0.01/8) No need to install anything. Regards, KL "Ron Green" <Ron wrote in message ... I would like to create a formula that rounds the sum of two cells to the nearest eighth of one percent. Specifically, Cell 1, 5.00%, plus Cell 2, 2.40%. The sum is 7.40%, but rounded to the nearest eighth it would be 7.375%. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| writing a formula for a colored value | New Users to Excel | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
Threaded Mode
