Matching a value, which does not exceed Min or Max.
 

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

Matching a value, which does not exceed Min or Max.
 

try:

=IF(E1<C1,"Balance Pending",IF(E1D1,"Extra Material Supplied","Material
Received"))

"Assad" wrote:

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

Matching a value, which does not exceed Min or Max.
 

" THANKS "

LIFE IS MUCH EASIER NOW...

IS THERE ANY EXCEL WORKING FILE WHICH COULD
CONTAIN FORMULA WITH WORKING ENVIROMENT EXAMPLE..

I HEARD ABOUT A FILE CALLED XLFDIC.XLS..

IF SOMONE KNOWS THIS OR ANYOTHER WORKING FILE, PLS TELL ME.

AGAIN THANKS FOR YOUR TIME " TOPPERS "

BYE.

ASSAD

"Toppers" wrote:

try:

=IF(E1<C1,"Balance Pending",IF(E1D1,"Extra Material Supplied","Material
Received"))

"Assad" wrote:

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

Matching a value, which does not exceed Min or Max.
 

http://homepage.ntlworld.com/noneley/

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Assad" wrote in message
...
" THANKS "

LIFE IS MUCH EASIER NOW...

IS THERE ANY EXCEL WORKING FILE WHICH COULD
CONTAIN FORMULA WITH WORKING ENVIROMENT EXAMPLE..

I HEARD ABOUT A FILE CALLED XLFDIC.XLS..

IF SOMONE KNOWS THIS OR ANYOTHER WORKING FILE, PLS TELL ME.

AGAIN THANKS FOR YOUR TIME " TOPPERS "

BYE.

ASSAD

"Toppers" wrote:

try:

=IF(E1<C1,"Balance Pending",IF(E1D1,"Extra Material Supplied","Material
Received"))

"Assad" wrote:

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