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
 
Top