Skip to main content
Solved

Treat cells with 0 and empty value differently

  • July 29, 2021
  • 1 reply
  • 28 views

Forum|alt.badge.img+2

Hello,

Cell value 0 is blank
Cell value 0.00 is blank
Cell value empty is also blank

How to treat cell with 0 value and empty cells differently?

All the following forumas are returning result for both the {Buy} cells that has zero value and the {Buy} cells that are empty.

I want result only for the cells that has 0 or more value not the cells that has empty values.

IF(AND(IF({Buy} >= -1, TRUE(), FALSE()),{Sell}), (Sell-Buy)*Lot*Qty)
IF(AND(IF(NOT({Buy} = 0), TRUE(), FALSE()),{Sell}), (Sell-Buy)*Lot*Qty)
IF(AND(IF({Buy} = BLANK(),  FALSE(), TRUE()),{Sell}), (Sell-Buy)*Lot*Qty)

Best answer by kuovonne

To test if a numeric field has a value including zero, concatenate it with an empty string …

IF({Buy} & "", "Buy has a value", "Buy is blank")

1 reply

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • July 29, 2021

To test if a numeric field has a value including zero, concatenate it with an empty string …

IF({Buy} & "", "Buy has a value", "Buy is blank")