Hi,

Try this

=ROUNDUP(A5,0)*A6

Mike

"Art Stretcher" wrote:

Sirs,
I can format a calculated cell value to display as the nearest whole number.
But is it possible to have that rounded whole number value (not the cell's
calculated fractional value) become the value recognized and used when it is
a term in follow-on fomulas?

For example; if cell A5 represents the number of bolts needed to attach a
frame and the next calculation uses A5 as a multiplier with A6, which is the
unit price-per screw and the you want the total cost to automate as the
answer in cell A7, then cell A5 needs to be a whole number.

Is this possible? If so, what do I need to do.

I appreciate your help!
--
A. Stretcher