ExcelBanter - Using the answer IF "true" in another formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using the answer IF "true" in another formula? (https://www.excelbanter.com/excel-worksheet-functions/84629-using-answer-if-true-another-formula.html)

Yvonne

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?

Yvonne

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?

All times are GMT +1. The time now is 11:53 AM.