Split value in half and add

[GregoryT]

A	500
B	750
C	750

<tbody>
</tbody>

How can I split A in half and add the half (250) to B & C to equal 1000 or it can not be done?

Thanks in advance GT

 

[Special-K99]

Lets establish something first..
A is not a cell reference, A1 is a cell reference.

So assuming the following.

A1=500
B1=750
C1=750

Cells can contain a value or a formula, not both.
Since B1 and C1 already contain a value you cant put a formula in them as well.
So you have to use other cells

in D1
=B1+A1/2
in E1
=C1+a1/2

Now use D1 and E1 instead of B1 and C1

 

[GregoryT]

Thank you so much, really appreciated your response.
GT