Excel

  • Thread starter Thread starter Richard Dye
  • Start date Start date
R

Richard Dye

How do we obtain help on spreadsheet queries?

We need to know how, if you enter a formula into a cell
which changes the value in another cell how the changed
value can be maintained in the second cell after deleting
the amount entered into the first cell.


Regards


Dickey
 
Hi Richard,
Specifically you want a formula to be used and then you want
that formula to change another cell and then for the formula
to disappear.

A formula cannot change the value in another cell.
Try to explain what you want to do and what you
have in a cell. It is unreasonable to try to answer a
question that is not clear.

The closest I can think of might be an Event macro
that creates a value in column B when a cell in Column A
changes, but does not change the value in column B when
Column A is cleared. With an Event macro you might
have the calculation within the macro. But without a clear question of
*exactly* what you want, I feel that it would be a waste of
time including your to try to answer and not provide a
correct answer.

Also the words "Excel" or "help" or "urgent" for that
matter have very little meaning in an Excel newsgroup.
So effectively you have entered a question without a subject
title. Please try to make the subject match the question,
and make sure that the question is clear.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Richard

You can't enter a formula in a cell and affect a second cell unless the second
cell also has a formula pointing to the first cell.

To keep values in a cell that derives its result from another cell, copy the
second cell and(in place) Paste Special>Values>OK.

Gord Dibben XL2002
 
Back
Top