IF formula with >= zero issue

[sydowa]

if [Account] = "1501" AND [End Bal Accounted] >= "0" then"Line 34" else"Line 32" endif

I have prepared the formula above, however all results default to "Line 32". I know my ending balances in account 1501 are both positive and negative. Am I not entering the >=0 correctly? The [Account] is a V_String and the [Ending Bal Accounted] is a double? 

[Luke_C · Accepted solution]

Hi @sydowa 

If End Bal is a double then you don't need quotes:

if [Account] = "1501" AND [End Bal Accounted] >= 0 then"Line 34" else"Line 32" endif

[binu_acs]

@sydowa I guess your Account is string type and End balance is numeric, in that case try the below formula

if [Account] = “1501” AND [End Bal Accounted] >= 0 then"Line 34" else"Line 32" endif

[sydowa]

thank you for your help!