D
DDD
Ok so i want to validate a cell that has a number in it like must be above 0.
I know how to do that.
However, from what i know this only works when the cell has a number entered
by you & not by a formula.
There may be a way to validate it but im sure that this may involve using
Visual basic, & i dont know who to use this.
Heres my question--------------------- --------------------
---------------
Does any one know how to enter a number into a cell by using a formula from
another cell
e.g.
5 entered into A1
3 entered into B1
=Sum(A1:B1) entered into C1 (Answer is 8)
D1 is blank
Ok so instead of validating C1 which has a formula within it, is it possible
to link the answer in C1 to D1 without adding a formula to D1 (Left blank)
This could be by using some feature excel has or modifying the formula in c1
like =Sum(A1:B1),ANSWERIN,D1 etc
I know how to do that.
However, from what i know this only works when the cell has a number entered
by you & not by a formula.
There may be a way to validate it but im sure that this may involve using
Visual basic, & i dont know who to use this.
Heres my question--------------------- --------------------
---------------
Does any one know how to enter a number into a cell by using a formula from
another cell
e.g.
5 entered into A1
3 entered into B1
=Sum(A1:B1) entered into C1 (Answer is 8)
D1 is blank
Ok so instead of validating C1 which has a formula within it, is it possible
to link the answer in C1 to D1 without adding a formula to D1 (Left blank)
This could be by using some feature excel has or modifying the formula in c1
like =Sum(A1:B1),ANSWERIN,D1 etc