I am attempting to set one cell (R6C20) as a value, a second cell
(R9C20) as a number and then have a third cell (R12C20) display the
deviation of (R6C20) from (R6C20).

I want to show by how much something has gone over or under an
allocation. I would like the value in (R12C20) to display as a
negative is it is under, all in whole numbers with no decimals.

Thanks in advance,
Forest

Fixed what I want the third cell to show below...


On Jun 9, 3:25*pm, wrote:
I am attempting to set one cell (R6C20) as a value, a second cell
(R9C20) as a number and then have a third cell (R12C20) display the
deviation of (R9C20) from (R6C20).

I want to show by how much something has gone over or under an
allocation. I would like the value in (R12C20) to display as a
negative is it is under, all in whole numbers with no decimals.

Thanks in advance,
Forest

I am a mooooron. =R9C20-R6C20

Will show a smaller actual number than the allocation as a neg (i.e. x
number below allocation) and a higher as a positive...

yay



On Jun 9, 3:35*pm, wrote:
Fixed what I want the third cell to show below...

On Jun 9, 3:25*pm, wrote:



I am attempting to set one cell (R6C20) as a value, a second cell
(R9C20) as a number and then have a third cell (R12C20) display the
deviation of (R9C20) from (R6C20).

I want to show by how much something has gone over or under an
allocation. I would like the value in (R12C20) to display as a
negative is it is under, all in whole numbers with no decimals.

Thanks in advance,
Forest- Hide quoted text -

- Show quoted text -