Home

Excel cap formula

pbruno2201
New Contributor
This is an excel function question. I have a range of numbers. I'd like to cap the numbers so that its average is a specific number. For example, I have a 2,4,8,3 that averages 4.25. However, I want to cap these numbers so that the average is 4%. In that case it would result in 7.