Split value in half and add

[GregoryT]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD]750[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD]750[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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