I was afraid I wouldnt explain it correctly.

On my worksheet I have a result of a formula in a cell on line 10 and in
another cell I have a result of another formula in a cell on line 13.
The result that goes on line 14 says: if line 10 is more than line 13 enter
amount here.
The result that goes on line15 says: if line 13 is more than line 10 enter
amount here.

Line 10 200.00 line 10 200.00
line 11
line 12
Line 13 150.00 line 13 400.00
Line 14 the answer should be 50.00 line 14
-
Line 15 - line 15 should be 200.00

Hope this helps explain it better. Thank you for your help.


"Russell Dawson" wrote:

I'm not sure whether I understand what you mean by "line 10" and "line 13".

If this doesn't suit you please explain what you mean.

=IF(A10A13,J31,H32)

I've assumed that the entry has to be the result in either j31 or h32 so if
it's not one then it has to be the other. Also a10 and a13 have been
substituted for line 10 and 13 until more information available.

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"kmjmail" wrote:

I am looking for a formula (excel 2003) that gives me the following
answer.
(in box 14) If line 10 is more than line 13 enter the answer J31
(in box 15) If line 13 is more than line 10 enter the answer H32


8 175227.44
9
10 175225.44
11 175227.18
12a 2967.75
12b 1
13 178194.93
14
15