| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the answer IF "true" in another formula?
Please help; I have an IF Function that contains a formula if "true". I am
trying to use the if "true" answer in another formula. Can this be done? 1st IF Function (in cell F5): =IF((C41),SUM(C4-D5),"") 2nd Formula(in cell H5): =sum(h4+F5) The sum(C4-C5) in cell F5 needs to be added to H4. Can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the answer IF "true" in another formula?
Please ignore this question daddylonglegs already helped me! Thanks:0)
"Yvonne" wrote: Please help; I have an IF Function that contains a formula if "true". I am trying to use the if "true" answer in another formula. Can this be done? 1st IF Function (in cell F5): =IF((C41),SUM(C4-D5),"") 2nd Formula(in cell H5): =sum(h4+F5) The sum(C4-C5) in cell F5 needs to be added to H4. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill down produces correct formula but wrong answer | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Linking worksheets and the formula shows up instead of the answer | Excel Discussion (Misc queries) | |||
| Formula giving incorrect answer... | Excel Discussion (Misc queries) | |||
| How do I calculate a formula with a not-to-exceed answer? | Excel Discussion (Misc queries) | |||
Linear Mode
