Excel Recursive function or not..! Pl help

I know golf but I'm struggling to understand what you want to do.

If your question is related to golf then explain it in a golf scenario.

I dont know gold and Im still struggling to understand what you are trying to do?

1+9 = 9?????

I know Im getting old, and things change in schools, but I didnt think they would change basic math?

ok, that is fair.So..

I am starting at hole no 1. If I play 9 holes, I end at hole number 9. If I play 18-hole round, I end at hole 18.
(so we are counting the hole that we start on..therefore 1+9=9...!)

If I play a 9-hole scramble, I can start only on the hole that I am assigned. Therefore I could start at hole 5, I end at hole 13. If I start at hole 13, I end at hole 3.
If I play a 18-hole scramble,I could start at hole 5, I end at hole 4. If I start at hole 13, I end at hole 12.

For those that are not golf-savvy
Front nine- 1 through 9 (holes)
Back nine - 10 through 18 (9 holes)
..and only in a tournament, start any hole and end after playing 9 or 18, hole 1 following hole 18.

I need to set up my excel so that I enter a starting hole and provide 2 scenarios (Playing 9 or 18, format of play - regular or scramble) and I should automagically be provided the finishing hole, completing the four columns- Starting hole,9/18, Format, Finish hole. Phew...a formula for the Finish Hole calculation is what I need to get.Savvy?

Maybe

	A	B	C	D
1	Starting	9/18	Format	End
2	5	9		4
3	4	18		3
4	1	9		9
5	1	18		18
6	2	9		1
7	14	18		13
8	8	9		7
9	9	9		8
10	18	18		17
11	17	18		16

Formula in D2 copied down
=IF(A2=1,B2,MOD(A2+B2-1,B2))

Are possible cases like these in the rows 13, 14 and 15 (red)?

If so, what are the expected results?

	A	B	C	D
1	Starting	9/18	Format	End
2	5	9		4
3	4	18		3
4	1	9		9
5	1	18		18
6	2	9		1
7	14	18		13
8	8	9		7
9	9	9		8
10	18	18		17
11	17	18		16
12	9	18		8
13	17	9		?
14	18	9		?
15	10	9		?

Thanks! It works for all cases except...[LIST] starting hole is not 1 and 9/18 is 9. In the table, rows 6,8,9

17 - 9 - 7 (17+9-1-18 = 7)
18 - 9 - 8 (18+9-1 = 8)
10 - 9 - 18 (10+9-1 = 18)

Basically, we need to recount starting from 1, after the summation goes over 18, if not remain as is.
I subtract 1 just to include the starting hole or its over by 1 all the time.

Re thinking

See if this is ok

	A	B	C	D
1	Starting	9/18	Format	End
2	5	9		13
3	4	18		3
4	1	9		9
5	1	18		18
6	2	9		10
7	14	18		13
8	8	9		16
9	9	9		17
10	18	18		17
11	17	18		16
12	9	18		8
13	17	9		7
14	18	9		8
15	10	9		18

Formula in D2 copied down
=IF(A2+B2-1<=18,A2+B2-1,MOD(A2+B2-1,B2))

Originally Posted by xsmash

Yes sir, that works with IF statements...!
But I don't want to use If statements, reason why I didn't mentioned the conditional statements in the first post.
There has to be a way, with a algebraic formula.
Or, I am not being a pest...and is this the only way?!

Well, I don't understand why you cannot use IF statements.

That said, try this formula in D2 copied down

=(A2+B2-1)*(A2+B2-1<=18)+MOD(A2+B2-1,B2)*(A2+B2-1>18)

(hope that MOD is not blacklisted...)

Originally Posted by xsmash

Beautiful, thanks for the help! I have some more burning queries..and I won't hesitate to ask!

You are welcome.

Originally Posted by Teethless mama

If you don't mind with this function IFERROR() then try this. It looks almost 50% shorter and much more elegant than mlcb has given you.


=IFERROR(1/(1/MOD(A2+B2-1,18)),18)

Nice Formula!

My formula, without IFs, can be shortened (simplified) and also be quite elegant

=MOD(A2+B2-1,19)+(A2+B2>19)

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.