Complicated IF formula

[jwaldmann]

Hi guys,

I have an inventory page and a main page. On the inventory page I have Total Quantity and then remaining. I have an If statement for each item IF( C1 >5, "Good", "Refill"). A1 is the product name, B1 is the total quantity, C1 is the remaining quantity, and D1 is the IF statement.

What I want is on the main page to display column A if the IF statement says "Refill". There might be more then 1 item that needs to be refilled. If everything says "Good" then nothing should be displayed. So if Milk and Chicken need to be refilled then on the Main page Cell A1 should be "Does anything need to be refilled?" and then A2 would display "Milk, Chicken" (or something like that).

Thanks guys,

Jonathan

[patsyhixon]

They usually recommend you upload a sample so it makes it easier to understand what you wanting and gives actual data to play with.

[jwaldmann]

Sorry 'bout that...

[Pepe Le Mokko]

Why not use a filter to get your answer?