Excel cap formula

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.

1 Reply
Hi! Make sure to post this in the excel forum as well!