Another if statement formula

Stacy Bobbitt

I have what I thought would be a simple formula: =IF([Total credits per tuition year]@row > [Permitted credits per year]@row, "True") the formula is parse able; however, it's returning true whether the total credits per tuition year are greater than the permitted credits or not, except for the first row. The first row is where I typically create all of my formulas and then, if possible, convert them to column formulas. The only thing that I can see to be different in the first row is this cell is not linked as the other cells are. Does that matter? I'm at a loss...HELP!

Mark Cronk

Hi @Stacy Bobbitt

Try this:

=iferror(IF([Total credits per tuition year]@row > [Permitted credits per year]@row, "True", "False"),"")

Looks like you omitted the value if false. I added an iferror to keep it clean.

Mark

Stacy Bobbitt

No, it didn't. Again, parse able but still not returning correct values.