Prev: Format Control Tab
Next: I am trying to write a macro using If...Then
From: kmjmail on 22 Mar 2010 10:47
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



From: Russell Dawson on 22 Mar 2010 11:56
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(A10>A13,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
>
>
>
 | 
Pages: 1
Prev: Format Control Tab
Next: I am trying to write a macro using If...Then