Sometimes, too many ()'s make formulas easier to read--sometimes, they hurt.

=ROUND(IF(O60=TRUE,AVERAGE(P42:Q43),IF(P58=P59,AVE RAGE(P58:P59),P60)),0)
or just
=ROUND(IF(O60=TRUE,AVERAGE(P42:Q43),IF(P58=P59,P58 ,P60)),0)

if p58=p59, then average(p58:p59) will be the same as either number:

average(3,3) = 3
average(3134,3134)=3134



NotExcelingNow wrote:

Or how else could you do something like that? I need a excel program to do
something similar to this:

=ROUND(IF(O60=TRUE,AVERAGE(P42:Q43),(IF(P58=P59,AV ERAGE(P58:P59),P60),0

--

Dave Peterson