Split value in half and add

GregoryT

New Member
Joined
Oct 30, 2019
Messages
10
A500
B750
C750

<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

Well-known Member
Joined
Nov 7, 2006
Messages
8,328
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
 

Forum statistics

Threads
1,082,551
Messages
5,366,268
Members
400,881
Latest member
DevelopedUnkown

Some videos you may like

This Week's Hot Topics

Top