I have three columns in which contain amounts of inventories for certain
items I need for my concession. An adjacent column would tell me how much to
order.
Ex. c5, d5 and e5 would have on hand amounts. g5 would tell me how much to
order. I tried to make it simple by using f5 to add the amount from the
three previous cell. So =if (f5=3,0,g5-f5) But with this I get 0 even when f5
is 2.
Not every f5 would equal three. Each item on my list would have their own
amounts that I would need to compare to and enter in column g. Any help would
be appreciated. Thanks in advance.