Adding an IF statement to a formula

deb_63_hydracor

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!

Genevieve P.

Hi @deb_63_hydracor

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

James Keuning

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

deb_63_hydracor

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

Genevieve P.

Hi @deb_63_hydracor

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

deb_63_hydracor

Thanks so much, that worked!! :)