Forum Discussion

pbruno2201's avatar
pbruno2201
Copper Contributor
Nov 28, 2018

Excel cap formula

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.

Resources