Validating a resultant number against a number

  • Thread starter Thread starter Pablo Fernandez
  • Start date Start date
P

Pablo Fernandez

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
 
Thanks barb for your interest in helping me.

If I have a result in the sum of the columns, it should no be greater than
say 30 pallets, so if the customer is entering data and after enetering 30
pallets he wants to enter another pallet (31) then an error messaje will let
him know that he is exceeding the specified amount which is 30,
 
Back
Top