View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Z Steve Z is offline
external usenet poster
 
Posts: 2
Default Require Minimum Amount When Entering Data

I have an estimating sheet that I made in Excel. I allow my estimators to
enter a percentage to markup materials, and Excel computes a selling price
based on cost.

I want the the data entry cell to require a minimum 10%. If they try to
enter a number less than 10%, I need Excel to warn them, or show some sort of
error.

Any ideas will be appreciated.

Thanks.

Steve