Skip to main content

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)

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")

Reply