Try this:

=CEILING(D2*0.8,1)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"wolvina" wrote in message
...
I need to know (in layman's terms) how to roundup in excel. I already have
a simple formula in a cell =(D2*.80) The answer is 6806.4. I need
that
number to round up the nearest dollar, or 6807. This simple (for some of
you) is been a beast for me and will be used in numerous cells and
spreadsheets. I cannot figure out what I'm missing!

THANKS for any help!!