Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Treat cells with 0 and empty value differently

Topic Labels: Formulas
Solved
Jump to Solution
344 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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)
1 Solution

Accepted Solutions

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

See Solution in Thread

1 Reply 1

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