simple If but not for me

[kfarley]

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.

 

[JP]

If F5 contains the number 2, your formula would return 0 under the
following conditions:

a) F5 contains the number '3'
b) G5 contains the number '2'


HTH,
JP

 

[pdberger]

kfarley --

I don't know if I'm missing something here, but don't you have to have
somewhere the number you want to keep on hand? Maybe that's the number in
F5. If so, then the formula in G5 would be =F5 - SUM(C5:E5), no?

HTH

 

[BoniM]

I think from your formula, that for this row, 3 is the inventory you want to
keep on hand, if you have three, you don't want to order any and if you
don't, you want to order enough to have 3, yes? You said that your minimun
to order would not always be three. If you would add a column to your table
for your minimum inventory, you could use the same formula for all rows and
not have to change it for each product.
So.... try something like this:
Col F: =SUM(C5:E5)
Col G: Enter your minimum desired inventory number (in your example 3)
Col H: =IF(F2<G2,G2-F2,0)
I think this will give you what you're looking for. Once you have it in row
5, you can then copy it down for all of the other rows.
Good luck!