FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Conditional Formula for Golf

  
   Mac (Home) -> Mac Excel RSS
Related Topics:
Formula needed for conditional formatting - Using XL2004 11.3.3 on imac intel System 10.4.9 Hi experts, looking for a formula to highlight rows. Columns are a to y, Rows approx 4500. In column P, I have blanks and numbers, Would like to highlight the whole row if column P has numbers >0 and <

Conditional formatting - I am trying to format a range of cells - simply filling them in grey if they are empty. However, they contain the What condition can I use to fill this cell if indeed it contains ? Many TIA Jay ___

Conditional formatting - Excel 2008 only allows three rules for

conditional formatting more than 3 conditions - Hiya, Is it possible to have for more than 3 thanks for your help!

conditional formating with drop-down list - I am wondering if there is any way to do I am creating a schedule. I have created a list of employee shifts that need to be filled every day. I have also made a schedule with all of my employees names going down one column and the dates..
Next:  Mac Excel: Excel and Scheduled tasks  
Author Message
raynerman

External


Since: Jul 31, 2008
Posts: 2



(Msg. 1) Posted: Thu Jul 31, 2008 8:57 am
Post subject: Conditional Formula for Golf
Archived from groups: microsoft>public>mac>office>excel (more info?)
Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a scoring spreadsheet for tracking a golf competition. In it, players have a handicap (1-2Cool and each hole has a stroke index (1-1Cool which signifies how easy each hole is (1 hard, 18 easy).

I am trying to work out a formula that assigns the right number of shots each player based on the handicap and stroke index.

For example, if I have a handicap of 21, I will get 1 shot on all 18 holes, and extra shot on the three hardest holes (those with SI of 1 to 3).

So the formula is to return a value of 0, 1 or 2.

Can anyone help? Thanks in advance!

Nigel
Back to top
Login to vote
raynerman

External


Since: Jul 31, 2008
Posts: 2



(Msg. 2) Posted: Sat Aug 02, 2008 12:57 pm
Post subject: Re: Conditional Formula for Golf [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Took some solving but in case someone else stumbles on this with a similar question, the shots are calculated by:

(where G4 is starting handicap and D9 down the SI column)

=IF(G$4>=($D9+1Cool,2,IF(G$4>=$D9,1,0))

Which makes the stableford points the interesting part. It doesn't work if a 19 handicap gets a hole in one on a par 5, but I think I can live with that...

(Where G9 the gross score, N9 the shots gained above and C9 the SI...)

=IF((G9-N9)=($C9-3),5,IF((G9-N9)=($C9-2),4,IF((G9-N9)=($C9-1),3,IF((G9-N9)=$C9,2,IF((G9-N9)=($C9+1),1,0)))))
Back to top
Login to vote
Display posts from previous:   
       Mac (Home) -> Mac Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
Categories:
 Windows Forums
 Game Forums
 Linux Forums
  Mac Forums
 PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact