creating specific formula (if, then, else?)
Hello, I want to create a numeric formula where if one cell is empty, then i want the the formula to give back 0, else, if it has a number inserted, then i want the outcome to be another cell - the...
Forum Discussion
The fields generally have a setting where null values are treated as 0, but you can probably also have it where you can set them as variables and go from there:
var number inventoryHand = if([Inventory on Hand] > 0, [Inventory on Hand], 0);
[Inventory Par] - $inventoryHand
-----
Hope this helps
------------------------------
Ryan Stanford
------------------------------
var number inventoryHand = if([Inventory on Hand] > 0, [Inventory on Hand], 0);
[Inventory Par] - $inventoryHand
-----
Hope this helps
------------------------------
Ryan Stanford
------------------------------
This formula could lead to a negative number being entered if the inventory on hand is greater than the par value.
To cover all bases,
var number inventoryHand = if([Inventory on Hand] > 0 and [Inventory on Hand] < [Inventory Par], [Inventory on Hand], 0);
------------------------------
Paul Peterson
------------------------------
To cover all bases,
var number inventoryHand = if([Inventory on Hand] > 0 and [Inventory on Hand] < [Inventory Par], [Inventory on Hand], 0);
------------------------------
Paul Peterson
------------------------------