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