Subject: MS EXCEL gurus - need your helpDoes anyone know if/how I can construct a formula which will average three values but not letting any one value exceed 100%? For example, if the 3 values are 100, 120, and 90, the formula would just average 100, 100 and 90. Thanks in advance for your help. |