simple If but not for me

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
Fri Mar 14 17:38:29 CDT 2008

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


On Mar 14, 6:12=A0pm, kfarley <kfar...@discussions.microsoft.com> wrote:
> 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. =A0c5, d5 and e5 would have on hand amounts. g5 would tell me how much=
to
> order. =A0I tried to make it simple by using f5 to add the amount from the=

> three previous cell. So =3Dif (f5=3D3,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 wo=
uld
> be appreciated. Thanks in advance.

pdberger
Fri Mar 14 18:29:02 CDT 2008

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

"kfarley" wrote:

> 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.

BoniM
Fri Mar 14 18:47:00 CDT 2008

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!


"kfarley" wrote:

> 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.