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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks so much, that worked!! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!