Excel - Setting Max value in a cell

J

Johnrs

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I am developing a price list for sales teams and want to set the maximum discount at 40% and therefore not allow a value >40% to be either inputed and/or effecting the ongoing calculation

Thanks Johnrs
 
C

CyberTaz

Select the cell then go to Data> Validation & follow your nose:)

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Operating System Snow Leopard with Excel 2008. 1
Colored cells from IF...Then... 4
Formulas in Chart Titles Axis Titles 4
How to create condition for a required field 3
Value assigned to text 2
Number of copies when printing is 256, how can I set it back to 1? 2
cannot enter a long series of numbers without excel changing them. 3
error with exel 1

Top