Formula help please

[Leanne]

Hi,

I know that this will be simple to do, but I've no idea
how to do it!

I want to look up the value of one cell, compare it to the
value of another (both are numbers) and display the
difference in the third cell in a positive or negative
format.
For example:
if A1: 101 and I was to compare the value of A2: 100,
A3 would be -1.

Please help

thanks in advance
Leanne

 

[Sandy Mann]

Hi Lenne,

Simply

=B1-A1

HTH

Sandy

 

[Leanne]

Thanks Sandy, I figured it out too... I was trying to make
it much harder than it was!!!..

is there any way I can insert "up" or "down" arrows as
well?

 

[Sandy Mann]

I think that you are talking about the OFFSET Function. To reference the
cell four rows above cell H11 try the formula:

=OFFSET(H11,-4,0) which is saying start from cell H11, (even if the formula
is in H11), and go up 4 rows and across zero columns.

=OFFSET(G11,-4,1) is referencing the same cell but starting from G11.

HTH.

Sandy