CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
trying to nest a formula
|
efisher162
Junior Member
Registered: Feb 2004
Location:
Country: United States
State: NJ
Certifications: MOUS
Working on:
Total Posts: 4
|
|
 trying to nest a formula
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
Report this post to a moderator
|
|
 02-09-05 11:12 PM
|
|
curiousgeorge
learn through asking
M
Registered: Jul 2003
Location:
Country: United States
State:
Certifications: MCSE, MCSA, Server+, Dell, HP, Other
Working on:
Total Posts: 1110
|
|
|
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.
__________________
MCSA Charter Member
MCSE Early Achiever
Server+
Dell certified
HP certified
Report this post to a moderator
|
|
|
02-10-05 12:51 AM
|
|
efisher162
Junior Member
Registered: Feb 2004
Location:
Country: United States
State: NJ
Certifications: MOUS
Working on:
Total Posts: 4
|
|
|
|
02-15-05 09:40 PM
|
|
|
Featured site: MCSE, MCSD, CompTIA, CCNA training videos
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is ON. |
|
ExamNotes forum archive
|
