Here is the scenerio:
Step 1.
Cell A1(length) is given a value of *300*
Cell A2(width of dividing factor) is given value of *32*
Cell A3 (value is reached by dividing A1 by A2) *9.38* in this case. I
need the value of A3 to be a whole number (round up or down depending on
the situation), so round down to *9* in this case.

Step 2.
Once A3 has been rounded to the nearest whole number can its value be
multiplied to A2's value and then replace the manualy entereded value
of A1? If so how?

I am running microsoft office 2000, and microsoft xp. Any assistance
would be greatful.


--
mhillis
------------------------------------------------------------------------
mhillis's Profile: http://www.excelforum.com/member.php...fo&userid=4644
View this thread: http://www.excelforum.com/showthread...hreadid=498683

You can easily get the number

=ROUND(A1/A2,0)*A2

but it cannot replace A1 as that needs the original value for the formula to
work. You will need to type it in.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mhillis" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Here is the scenerio:
> Step 1.
> Cell A1(length) is given a value of *300*
> Cell A2(width of dividing factor) is given value of *32*
> Cell A3 (value is reached by dividing A1 by A2) *9.38* in this case. I
> need the value of A3 to be a whole number (round up or down depending on
> the situation), so round down to *9* in this case.
>
> Step 2.
> Once A3 has been rounded to the nearest whole number can its value be
> multiplied to A2's value and then replace the manualy entereded value
> of A1? If so how?
>
> I am running microsoft office 2000, and microsoft xp. Any assistance
> would be greatful.
>
>
> --
> mhillis
> ------------------------------------------------------------------------
> mhillis's Profile:
http://www.excelforum.com/member.php...fo&userid=4644
> View this thread: http://www.excelforum.com/showthread...hreadid=498683
>

Hi

=ROUND(A1/A2,0)

=A2*ROUND(A1/A2,0)

Copy A2, select A1, PasteSpecial (from Edit menu, or from right-click
dropdown) > Values


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"mhillis" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Here is the scenerio:
> Step 1.
> Cell A1(length) is given a value of *300*
> Cell A2(width of dividing factor) is given value of *32*
> Cell A3 (value is reached by dividing A1 by A2) *9.38* in this case. I
> need the value of A3 to be a whole number (round up or down depending on
> the situation), so round down to *9* in this case.
>
> Step 2.
> Once A3 has been rounded to the nearest whole number can its value be
> multiplied to A2's value and then replace the manualy entereded value
> of A1? If so how?
>
> I am running microsoft office 2000, and microsoft xp. Any assistance
> would be greatful.
>
>
> --
> mhillis
> ------------------------------------------------------------------------
> mhillis's Profile:
> http://www.excelforum.com/member.php...fo&userid=4644
> View this thread: http://www.excelforum.com/showthread...hreadid=498683
>

Yes but only with code, and then you lose all auditability because the data
is gone. Can you explain what it is you are doing that requires you to
reuse that same cell. It's easy to get that number in another cell.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"mhillis" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Here is the scenerio:
> Step 1.
> Cell A1(length) is given a value of *300*
> Cell A2(width of dividing factor) is given value of *32*
> Cell A3 (value is reached by dividing A1 by A2) *9.38* in this case. I
> need the value of A3 to be a whole number (round up or down depending on
> the situation), so round down to *9* in this case.
>
> Step 2.
> Once A3 has been rounded to the nearest whole number can its value be
> multiplied to A2's value and then replace the manualy entereded value
> of A1? If so how?
>
> I am running microsoft office 2000, and microsoft xp. Any assistance
> would be greatful.
>
>
> --
> mhillis
> ------------------------------------------------------------------------
> mhillis's Profile:
> http://www.excelforum.com/member.php...fo&userid=4644
> View this thread: http://www.excelforum.com/showthread...hreadid=498683
>

Thank you all for the help. I ended up just puting the value into a ne
cell instead of replacing the original value

--
mhilli
-----------------------------------------------------------------------
mhillis's Profile: http://www.excelforum.com/member.php...nfo&userid=464
View this thread: http://www.excelforum.com/showthread.php?threadid=49868