question

lfox2 

Hi,

You may apply Custom Data validation to the cell or range where you want to create the formula with upper and lower limits. To do that, 

Select the destination range

Go to the Data Tab and click on data Validation (Shortcut is Alt , D ,L)

Under "Allow" select ► "Custom"

Under Data ► Select Between

Type the Min and Max values and hit OK

If the result of the function violates the Upper or lower limit ► you get an error message.
Please Note that You cannot create a Formula/ Function in a cell then copy it because copying overwrites the Data Validation.
You can create a very simple code to prevent overwriting  the Data validation, here is a link:
https://www.youtube.com/watch?v=9JhCT6VMzBQ 
Hope that helps

Good Luck
Nabil Mourad