Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple If but not for me
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*pm, 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple If but not for me
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple If but not for me
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |