IF formula with >= zero issue

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?

Help

Accepted answers

Luke_C

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

All comments

Luke_C

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!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335