#1   Report Post  
Posted to microsoft.public.excel.misc
neo314trinity
 
Posts: n/a
Default golf handicap

Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1 then
b4=b3-2 but if b1=3 & b2=4 then b4=b3
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default golf handicap

Hi!

Here's a sample file that will give you some ideas:

http://s54.yousendit.com/d.aspx?id=3...D29PSG68HQ9SSC

It'll handle handicaps up to 54.

Biff

"neo314trinity" wrote in message
...
Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1
then
b4=b3-2 but if b1=3 & b2=4 then b4=b3



  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default golf handicap

To do what you've asked you would put this formula in B4:

=if(and(b1=36,b2=1),b3-2,if(and(b1=3,b2=4),b3,"?"))

I don't know what this has to do with golf handicaps though.

--
Regards,
Fred


"neo314trinity" wrote in message
...
Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1 then
b4=b3-2 but if b1=3 & b2=4 then b4=b3



  #4   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default golf handicap

=if(and(b1=36,b2=1),b3-2,if(and(b1=3,b2=4),b3,"?"))

I don't know what this has to do with golf handicaps though.


My interpretation:

B1 is the players hdcp
B2 is the hole hdcp
B3 is the players gross score for that hole

Biff

"Fred Smith" wrote in message
...
To do what you've asked you would put this formula in B4:

=if(and(b1=36,b2=1),b3-2,if(and(b1=3,b2=4),b3,"?"))

I don't know what this has to do with golf handicaps though.

--
Regards,
Fred


"neo314trinity" wrote in message
...
Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1
then
b4=b3-2 but if b1=3 & b2=4 then b4=b3





  #5   Report Post  
Posted to microsoft.public.excel.misc
neo314trinity
 
Posts: n/a
Default golf handicap

Thanks Biff
just what i needed and your interpretation was spot on!
"Biff" wrote:

Hi!

Here's a sample file that will give you some ideas:

http://s54.yousendit.com/d.aspx?id=3...D29PSG68HQ9SSC

It'll handle handicaps up to 54.

Biff

"neo314trinity" wrote in message
...
Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1
then
b4=b3-2 but if b1=3 & b2=4 then b4=b3






  #6   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default golf handicap

You're welcome. Thanks for the feedback!

Biff

"neo314trinity" wrote in message
...
Thanks Biff
just what i needed and your interpretation was spot on!
"Biff" wrote:

Hi!

Here's a sample file that will give you some ideas:

http://s54.yousendit.com/d.aspx?id=3...D29PSG68HQ9SSC

It'll handle handicaps up to 54.

Biff

"neo314trinity" wrote in
message
...
Newbie alert, could anyone help with a formula for this: if b1=36 &
b2=1
then
b4=b3-2 but if b1=3 & b2=4 then b4=b3






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
golf handicap 4 of last 5 scores Golf.nut1 Excel Discussion (Misc queries) 15 April 3rd 08 06:11 AM
excel for tracking golf scores or handicap RJ Excel Discussion (Misc queries) 0 January 17th 06 05:38 AM
golf handicap Phineus Excel Discussion (Misc queries) 4 July 4th 05 03:16 AM
Golf Handicap Using Last 5 Scores Golf League Schedule Excel Worksheet Functions 5 May 13th 05 12:14 AM
Golf Handicap Dick Gwin Excel Worksheet Functions 3 March 2nd 05 04:07 PM


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"