|
Home > Archive > Certifications and IT jobs/Salaries > February 2005 > trying to nest a formula
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
trying to nest a formula
|
|
| efisher162 2005-02-09, 6:12 pm |
| For those of you who are getting certified in MOS. Although this isn't direclty related to an exam it might be good practice. For a spread sheet at work I am trying to Average a range of cells and Round the answer. I've tried nesting the function and using an "If" style formula statements but keep coming up with a circular formula. righ now the formula looks like this
=IF(AVERAGE(D9:G9)>1,ROUND(H9,0))
and with this I get 0.0 for an answer. where the averagre should be more like 8.
Any help you brillant folks can give in this regard will be greatly apperciated
Thanks | |
| curiousgeorge 2005-02-09, 7:51 pm |
| I tried your formula and it worked for me. But this assumes that H9 is has the formula
=AVERAGE(D9:G9)
You can simplify it by using this nested formula
=ROUND(AVERAGE(B4:B9),0)
Hope that helps. | |
| efisher162 2005-02-15, 4:40 pm |
| Thanks it worked! |
|
|
|
|