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?
|