need help with an IF function
I am trying to come up with a cell formula that is a simple difference function, but I need it to be triggered by the number in another cell. It is for an inventory/ordering sheet. Someone will count the inventory and type in the "QTY ON HAND". there is also a column for "MINIMUM QTY NEEDED" which is preset and static. I just want to take the "DESIRED QTY" minus "QTY ONHAND", but I only want to trigger this function if the "QTY ON HAND" is lower than the "MINIMUM NEEDED"
I came up with this sentance, but it is not properly expressed so I'd love some help cleaning it up.
=IF([QTY ON HAND]1<[MINIMUM NEEDED QTY ON HAND (OR REORDER POINT)]1), ([DESIRED QUANTITY ON HAND]1-[QTY ON HAND]1)
I'm not sure if it should be IF OR SUMIF, or something else completely
Let me know if I need to clarify further
Thanks so much!
Help Article Resources
Check out the Formula Handbook template!