| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round up Formula Help
Richard wrote:
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. I think you want: F1: =roundup(E1,0) - E1 Note that I am interpreting you literally when you say "round up". The formula above will put $0.99 into F1 if E1 is $1.01. Is that what you want? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round up Formula Help
in F1 type:
=ROUND(E1,0)-E1 Alternatively, if you always want to round up and never down, in F1 type: =ROUND(E1+0.49,0)-E1 Regards, "Richard" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round up Formula Help
F1 =CEILING(E1,1)-E1
"Richard" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
