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

Try moving the closing parentheses to the end of the formula:
IFERROR([Last Billed User Count in QB]@row  [Total Licenses in Exp]@row, "0")
See: IFERROR Function
Cheers!
Genevieve
Answers

iferror([Last Billed User Count in QB]@row  [Total Licenses in Exp]@row),"0"

That was fast, thank you! However now I'm getting #UNPARSEABLE. :(

Try moving the closing parentheses to the end of the formula:
IFERROR([Last Billed User Count in QB]@row  [Total Licenses in Exp]@row, "0")
See: IFERROR Function
Cheers!
Genevieve

Thanks so much, that worked!! :)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!