Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2011, 07:12 AM
JimS378 JimS378 is offline Nested IFs Windows 7 64bit Nested IFs Office 2003
Novice
Nested IFs
 
Join Date: Apr 2011
Posts: 5
JimS378 is on a distinguished road
Default

I have a list of golf rounds data, with handicap differencials in column G. I need, based on the number of rounds in the list, to average a different number of differencials based on how many rounds have been played. I as going to use nested if's - for example:
=IF(G05>0,AVERAGE(G05:G14),IF(G06>0,AVERAGE(G06:G1 4), etc...
This would require about 20 nested IFs.
Guess I misinterpreted what I read about 64 IFs allowed.

Currently, the data is residing in Row 05 to row 24, with the available data ending at row 24 (variable nr of blank lines beginning in row 05). Based on the nr of available lines of data, I need to average a variable nr of cells in column G.

I think the last ELSE argument can point to a continuation cell (to chain together the nested IFs) but not sure how to have the result always end up in the right cell without absolute referencing.


Here is the HELP text that I was referring to. It made me think more than 8 IFs could be nested...

Up to 64 IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. (See Example 3 for a sample of nested IF functions.)

Any advise appreciated, thanks in advance.



Jim S
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with nested cylinders and labels pixmanlajunta PowerPoint 0 01-18-2010 11:25 AM
Nested if formulat to merge cells cristi22 Excel 0 10-23-2006 08:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft