Complex IF statement using columns containing formulas
Hoping there is a solution for this or a different way I can accomplish it.
I have an IF statement in a column where the False portion is a formula referencing two columns that are formulas. I get #Invalid Operation. I know it's due to the false portion based on testing the conditions in the IF statement and just testing out a simple formula rather than the whole IF statement where I subtracted the two columns and got same error.
The formula I'm using in the column with the error is:
=IF(AND(ISBLANK([Start POI]@row), [Rule Type]@row = "Speed Limit"), ([Speed Limit (km/h) Final]@row - [Speed (km/h)]@row), IF(AND(ISBLANK([Start POI]@row), [Rule Type]@row <> "Speed Limit"), "", [Speed Limit (km/h) Final]@row - [POI Speed Limit]@row))
Any ideas or help would be much appreciated. Thank you!!
Help Article Resources
Check out the Formula Handbook template!