Problem with if function in excel
 

I have 20 (F19-F39) raws in Comlumn F,

in cell F4 - i am trying to us mathfunction to show altest value I put in
F19-F39. I am adding new values in column A (F19-F39) as I go. I want to see
the latest value added in F19-F39 in cell A4.

Hoe can I do? I am using this formula, but it doesnt work from F31 onward.

=IF(F390,F39,IF(F380,F38,IF(F370,F37,IF(F360,F 36,IF(F350,F35,IF(F340,F34,IF(F330,F33,IF(F320 ,F32,))))))))

please reply on this address too, if possible

Problem with if function in excel
 

On Sun, 28 Feb 2010 22:46:01 -0800, panchal jignesh <panchal
wrote:

I have 20 (F19-F39) raws in Comlumn F,

in cell F4 - i am trying to us mathfunction to show altest value I put in
F19-F39. I am adding new values in column A (F19-F39) as I go. I want to see
the latest value added in F19-F39 in cell A4.

Hoe can I do? I am using this formula, but it doesnt work from F31 onward.

=IF(F390,F39,IF(F380,F38,IF(F370,F37,IF(F360, F36,IF(F350,F35,IF(F340,F34,IF(F330,F33,IF(F32 0,F32,))))))))

please reply on this address too, if possible



=LOOKUP(2,1/(F19:F390),F19:F39)

will return the last non-zero value in f19:f39

If it is possible for a value to be a zero, then:

=LOOKUP(2,1/(F19:F39<""),F19:F39)

might be better.

Also, if there will never be any blanks, you could also try:

=OFFSET(F18,COUNT(F19:F39),0)

--ron

Problem with if function in excel
 

"panchal jignesh" wrote:
I am adding new values in column A (F19-F39)
as I go. I want to see the latest value added in
F19-F39 in cell A4.

Try the following in A4:

=lookup(1E307,F19:F39)

If you would like the formula to work even when there are no numbers in that
range, then:

=if(count(F19:F39), lookup(1E307,F19:F39), "")


----- original message -----

"panchal jignesh" wrote:
I have 20 (F19-F39) raws in Comlumn F,

in cell F4 - i am trying to us mathfunction to show altest value I put in
F19-F39. I am adding new values in column A (F19-F39) as I go. I want to see
the latest value added in F19-F39 in cell A4.

Hoe can I do? I am using this formula, but it doesnt work from F31 onward.

=IF(F390,F39,IF(F380,F38,IF(F370,F37,IF(F360,F 36,IF(F350,F35,IF(F340,F34,IF(F330,F33,IF(F320 ,F32,))))))))

please reply on this address too, if possible

Problem with if function in excel
 

Thanks, It works, Great Job.,

"Ron Rosenfeld" wrote:

On Sun, 28 Feb 2010 22:46:01 -0800, panchal jignesh <panchal
wrote:

I have 20 (F19-F39) raws in Comlumn F,

in cell F4 - i am trying to us mathfunction to show altest value I put in
F19-F39. I am adding new values in column A (F19-F39) as I go. I want to see
the latest value added in F19-F39 in cell A4.

Hoe can I do? I am using this formula, but it doesnt work from F31 onward.

=IF(F390,F39,IF(F380,F38,IF(F370,F37,IF(F360, F36,IF(F350,F35,IF(F340,F34,IF(F330,F33,IF(F32 0,F32,))))))))

please reply on this address too, if possible



=LOOKUP(2,1/(F19:F390),F19:F39)

will return the last non-zero value in f19:f39

If it is possible for a value to be a zero, then:

=LOOKUP(2,1/(F19:F39<""),F19:F39)

might be better.

Also, if there will never be any blanks, you could also try:

=OFFSET(F18,COUNT(F19:F39),0)

--ron
.

Problem with if function in excel
 

On Mon, 1 Mar 2010 08:30:01 -0800, panchal jignesh
wrote:

Thanks, It works, Great Job.,

You're welcome. Glad to help. Thanks for the feedback.
--ron