Hi.

I am making Material Received Datasheet.

It goes like this,

Min Order Quantity..( 1000 Pcs ) = C1
Max Allowed Quantity ( 1200 Pcs ) = D1
Material Received Quantity ( for example 1100 ) = E1

Now I have to make a status or Order Received Quantity in Column F1

I wish to find a solution by putting up a formula, which shall compare
Material Received Quantity against Two Cells ( Min Order Quantity & Maximum
Allowed Quantity ).

So if we received material quantity less than order quantity, it shall
say.... Balance Pending.
Or
If we received material quantity over than the Max Allowed Quantity, it
shall say.... Extra Material Supplied.

Furthermore, if the Material Received Quantity is well within ( Min & Max )
than it should say ( formula ) Material Received.

I tried by using =IF(AND(),) Formula, but no luck.

Anybody, out there with better knowledge of Formula. Please Help me..

Bye.

Assad