| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I round a number to the nearest .49 in a cell that has a fo
I am a novice, but I think this is close to what I'm trying to acheive. I
have a column of numbers that I need to double whose sum is then added to itself. Then I need it to round up (.01 - .48) to .49, or (.50 to .98) to ..99. I started with =SUMPRODUCT(E3*50%+E3) but got confused as to how I would apply the "round" function. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number to the Nearest .25 | Excel Worksheet Functions | |||
| How can you round a number to the nearest 900? | Excel Discussion (Misc queries) | |||
| How do I round a number to the nearest 900? | Excel Discussion (Misc queries) | |||
| How can you round a number to the nearest 900? | Excel Worksheet Functions | |||
| How can I round a number to the nearest "50" or "100" in excel 200 | Excel Worksheet Functions | |||
Threaded Mode
