ENDIF causing issues in IF formula?

[jwlam]

Hi all,

I am trying to use operators on a formula that I've changed to a numeric data type. The formula doesn't give me an error until I type ENDIF. Data Type within Formula tool is Float (has decimals) and I've used the Select tool to change CPE and Max Credit to Float and tried Double just to see what would happen. Both give me the Malformed IF Statement error. What am I doing wrong here?

Thanks.

[adamweaver39 · Accepted solution]

Hey @jwlam ! I think you are missing your ELSE condition at the end of the formula before your ENDIF

[jwlam]

@adamweaver39 Ahh I knew it was a simple solution. Thanks!

[adamweaver39]

Sure thing :) glad it was that easy!