Prev: Adding formula
Next: how do i import data from my excel worksheet into quickbooks
From: Huseyin on 17 Feb 2010 23:47
A B C D
A1 10
A2 9 1
A3 8 2 1
A4 7 3 2
A5 6 4 3 1

I need to calculate the differences of each value in a column and have the
answers on second third column. For example subtract A2 from A1, A3 from A1,
A4 from A1, A5 from A1; and subtract A3 from A2, A4 from A2, A5 from A2;
subtract A4 from A3, A5 from A4; and finally subtract A5 from A4.

Any help is appreciated.
From: teylyn on 18 Feb 2010 02:32

Hi, try this

select B2:B5 and enter this formula in B2 =$A$1-(A2:A5), confirm with
Ctrl-Shift-Enter.
similarly for
C3:C5 =$A$2-(A3:A5)
D4:D5 =A3-(A4:A5)

hth

teylyn
'The Code Cage - Microsoft Office Help - Microsoft Office Discussion'
(http://www.thecodecage.com)




H
u
s
e
y
i
n
;
6
4
6
8
0
7

W
r
o
t
e
:


>
A B C D
> A1 10
> A2 9 1
> A3 8 2 1
> A4 7 3 2
> A5 6 4 3 1
>
> I need to calculate the differences of each value in a column and have
the
> answers on second third column. For example subtract A2 from A1, A3
from A1,
> A4 from A1, A5 from A1; and subtract A3 from A2, A4 from A2, A5 from
A2;
> subtract A4 from A3, A5 from A4; and finally subtract A5 from A4.
>
> Any help is appreciated.


--
teylyn

Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=180302

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

 | 
Pages: 1
Prev: Adding formula
Next: how do i import data from my excel worksheet into quickbooks