Data Validation for Percentages

[Barbara Bell]

I am trying to set up a worksheet that allows the user to
input an interest rate and see what the various loan and
interest amounts would be. How do I set up a data
validation where the interest rate cannot be greater than
8.01%?

 

[J.E. McGimpsey]

See one answer in .worksheet.functions

This message has nothing to do with charting. Please don't post the
same message to multiple groups - it just fragments any replies and
wastes the time of those answering. Most regulars read .misc,
..programming and .worksheet.functions, so one of those should
suffice.

For tips on using these groups effectively, see http://cpearson.com/excel/newposte.htm