P
panchal jignesh
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(F39>0,F39,IF(F38>0,F38,IF(F37>0,F37,IF(F36>0,F36,IF(F35>0,F35,IF(F34>0,F34,IF(F33>0,F33,IF(F32>0,F32,))))))))
please reply on this address too, if possible
(e-mail address removed)
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(F39>0,F39,IF(F38>0,F38,IF(F37>0,F37,IF(F36>0,F36,IF(F35>0,F35,IF(F34>0,F34,IF(F33>0,F33,IF(F32>0,F32,))))))))
please reply on this address too, if possible
(e-mail address removed)