G
Guest
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
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