Round up Formula Help Richard 30.09.2006 16:40:02 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.

Re: Round up Formula Help joeu2004[ at ]hotmail.com 30.09.2006 17:14:47 Richard wrote: [Quoted Text] > 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?

RE: Round up Formula Help sb1920alk 30.09.2006 17:20:01 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: [Quoted Text] > 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.