Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up Formula Help
If cell E1 has, lets say $1.75 in it. Is there a way to leave E1 as it is
$1.75, BUT round it up to the nearest dollar and put the difference only .25 in cell F1. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to round up to nearest 1,000 | Excel Discussion (Misc queries) | |||
Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions | |||
Formula to enter to round an Excel value up to the next $0.5? | Excel Discussion (Misc queries) | |||
If the SUM of a list is 32.2 what formula to round it up to 32.5? | Excel Worksheet Functions | |||
Using ROUND formula to calculate tax | Excel Worksheet Functions |