| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel function solve problem? | Excel Worksheet Functions | |||
| excel function problem | Excel Worksheet Functions | |||
| Sum and If Function Problem with Excel 2007 | Excel Worksheet Functions | |||
| IF Function Problem Excel 2000 | Excel Worksheet Functions | |||
| Problem with Excel SUM function | Excel Worksheet Functions | |||
Threaded Mode
