Formula in cell A1 to put a value in A2

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

sowetoddid

SPREADSHEET DESCRIPTION: I have a spreadsheet that is setup to convert
one unit to another unit. The conversions are fairly involved and
include several steps.

Several of the steps happen to have similar variables (ex. HP). HP
(HorsePower) shows up in three different places on the spreadsheet. Is
there a way that...when the user inputs the HP value into one of the
three cells, the other two will automatically be filled with the same
value?

The problem is that the user can fill the value into any one of the
three HP cells. So, I cannot simply put a formula directly into two of
the HP cells...it would get erased as soon as the user adds a value to
the cell.


Any ideas??
 
sowetoddid said:
SPREADSHEET DESCRIPTION: I have a spreadsheet that is setup to convert
one unit to another unit. The conversions are fairly involved and
include several steps.

Several of the steps happen to have similar variables (ex. HP). HP
(HorsePower) shows up in three different places on the spreadsheet. Is
there a way that...when the user inputs the HP value into one of the
three cells, the other two will automatically be filled with the same
value?

The problem is that the user can fill the value into any one of the
three HP cells. So, I cannot simply put a formula directly into two of
the HP cells...it would get erased as soon as the user adds a value to
the cell.
Click to expand...

No. You must have the user input to one specific cell and have formulas in
the other two cells referencing that input cell. A formula in a cell can
only return a result to that cell. It cannot put a result in another cell.
 
You can't have it both ways, it is possible using VBA and a sheet event
macro but a formula
can only return something in the cell that holds the formula and of course
it will
be overwritten if the user types something there, consider change the design
so that if you have
3 cells where the user can type into you could have a formula in a 4th cell
reacting to any of those cells.
 
Hi

Why do you need several inputs there? I think you need 3 cells for input at
all - start value, start unit, and unit to convert to (And a cross-table
with coeficients on hidden sheet, which isn't accesible for user). And both
unit fields are better drop-downs to avoid any typing errors.
 
Back
Top