ExcelBanter - Conditional formula

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

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

- - Conditional formula (https://www.excelbanter.com/excel-worksheet-functions/230129-conditional-formula.html)

Greg

Conditional formula

I am trying to create a formula where if C390 then add c7+ C8+ c9 and place
the result in cell c37.
I know this is not a difficult one but I rarely do if then statements.
Thank you for your help in advance.
Greg

Mike H

Conditional formula

Try this

=IF(C390,SUM(C7:C9),"")

Mike

"Greg" wrote:

I am trying to create a formula where if C390 then add c7+ C8+ c9 and place
the result in cell c37.
I know this is not a difficult one but I rarely do if then statements.
Thank you for your help in advance.
Greg

All times are GMT +1. The time now is 10:47 AM.