Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi everybody.
I em making a purchase order fomrat with the capability of a Kanban supply system, and I need the customer to order no more than the specified pallets of product. I have several columns where the customer will enter the amount of pallets neded for each product, and then at the end the format will sum all the pallets, but I need a function so that when the customer enter the amounts and the sum of the pallets in the bottom, passes the specification, a message error pops up to indicates the client that he had passed the limit of pallets to order. I tried the "Validation" function in the Data menu, but it does not recognizes the sum as a whole number. I hope you can help me -- Kind Regards Pablo Fernandez |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
divide a resultant number into another number | Excel Discussion (Misc queries) | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Validating a Number ID | New Users to Excel | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |