excel formula

Cap percentage between 0 and 100!   Sometimes, you need to limit values in Excel to a certain allowed range. For example, you might need to make sure that all percentages are between zero (0) and 100%. In other words, prevent negative values and values over 100%. The classic way to do this is with