yes, you can do that, almost exactly. you just need some more
paretheses, i think............

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

i don't have it quite right, yet, it says there's an error. i'm
horrible with nesting formulas & having the correct number of
parentheses & arguments! a tip, tho - when you're constructing the
formula up in the formula bar as you move the cursor from parenthesis
to parenthesis, they are different colors and light up so you can make
sure you've got an opening one & a closing one.
hope it got you started, at least!
:)
susan


On Jan 9, 3:58*pm, 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