a bit of programming - limiting the total amount

  • Thread starter Thread starter Aboiy Davantes
  • Start date Start date
A

Aboiy Davantes

hi Im here again,

I would like to ask your help if you could possibly find a
way for this calculation.

question : in a certain column if it reach to a certain
amount lets say $7,000, it will limit the user to input
another amount instead it will be redirected to another
column or it will give a certain message to the user, so
as to avoid over purchasing.

Thanks once again to all of you.

aboiy
 
Hi Aboiy

Select the cells in question, then go menu Data > Validation. There's a
wizard, allow integer or decimal numbers <= 7000 and set up the proper
messages there.
 
Back
Top