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
Check out the Formula Handbook template!