cell value functioning as whole number in formulas
 

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

cell value functioning as whole number in formulas
 

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

cell value functioning as whole number in formulas
 

Since your calculated value in A5 represents the number of units of a real
world item, I would not think you would ever want that number rounded
downward... I would think (for your case) a fraction of a bolt should count
as a whole bolt. Formatting the cell value as a whole number will round
fractional values less than 0.5 downward. Instead of using cell formatting,
why don't you encase your calculation in A5 with the ROUNDUP function like
this...

C5: =ROUNDUP(<<your current formula goes here,0)

Now, your other formulas that reference C5 will see the rounded up number
(there will no longer be any fractional value to worry about) and so they
will calculate as you want them to.

--
Rick (MVP - Excel)


"Art Stretcher" wrote in message
...
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

cell value functioning as whole number in formulas
 

Thanks, Mike. Worked like a charm!

--
A. Stretcher


"Mike H" wrote:

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

cell value functioning as whole number in formulas
 

Very helpful, Rick. Thanks for the solution.
--
A. Stretcher


"Rick Rothstein" wrote:

Since your calculated value in A5 represents the number of units of a real
world item, I would not think you would ever want that number rounded
downward... I would think (for your case) a fraction of a bolt should count
as a whole bolt. Formatting the cell value as a whole number will round
fractional values less than 0.5 downward. Instead of using cell formatting,
why don't you encase your calculation in A5 with the ROUNDUP function like
this...

C5: =ROUNDUP(<<your current formula goes here,0)

Now, your other formulas that reference C5 will see the rounded up number
(there will no longer be any fractional value to worry about) and so they
will calculate as you want them to.

--
Rick (MVP - Excel)


"Art Stretcher" wrote in message
...
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