Sum difference between two cells only if one cell is not blank

heyjaims

Hello. I am trying to write a formula that calculates the difference between the "Pitch $" and the "Closed Deal $" only when the "Closed Deal $" cell has a value (aka I don't want inaccurate values reflected in the "Pitched to Closed $ Difference" cell because it's considering a blank cell to be $0). Help?

Michael Coulson

will this work?

=IF([Closed Deal $]@row="","",[Closed Deal $]@row-[Pitch $])

Michael Coulson

will this work?

=IF([Closed Deal $]@row="","",[Closed Deal $]@row-[Pitch $])

heyjaims

Thank you @Michael Coulson - that seems to work! I found the ISBLANK works as well. Formula rookie over here.