Adding an IF statement to a formula


I'm using the formula below to subtract numbers in two columns and provide the answer in a third. Some of the cells in the first column don't have numbers (there are words) so I am getting an #INVALID OPERATION error which I expected. I want to add an IF statement to the formula to return "0" in place of that error (not trying to eliminate the error, just trying to make the sheet look better for use in a report) but don't know where to begin. If it helps, the cells that contain words instead of a number also have a corresponding checkbox column. Thanks in advance for your help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!