Can this be done? If so, how?

M

mhillis

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.
 
B

Bob Phillips

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)
 
A

Arvi Laanemets

Hi

=ROUND(A1/A2,0)

=A2*ROUND(A1/A2,0)

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

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
M

mhillis

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