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.
No RepliesBe the first to reply

Resources