IF formula with >= zero issue
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you for your help!