Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel columns do they exceed IV? | Excel Worksheet Functions | |||
Exceed Scale | Charts and Charting in Excel | |||
The number of hours in a day cannot exceed 24... | Excel Worksheet Functions | |||
exceed maximum rows | Excel Discussion (Misc queries) | |||
determining slopes that exceed x | Excel Discussion (Misc queries) |