Thread: Problem with if function in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
panchal jignesh panchal jignesh is offline
external usenet poster
  
Posts: 1
Default 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



Reply With QuoteReply With Quote