Skip to main content
Question

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 number inserted cell

1st Cell) Inventory par (always going to be 9)
2nd Cell) Inventory on hand (insert a number)
3rd Cell) Inventory to order (0 if nothing is inserted, otherwise ([inventory Par] - [inventory on hand]))

Please advise,
Thank you

------------------------------
Brandon Hermez
------------------------------
This topic has been closed for replies.

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
------------------------------
Terms & ConditionsAccessibility statement