Problem With Formula

[The Shadowman]

=IF(U8<34,T8+1,IF(U8="dnp",T8,IF(U8=34,T8,IF(U8=35,T8,IF(U8=36,T8,IF(U8=37,T8,IF(U8=38,T8-1,IF(U8=39,T8-1,IF(U8=40,T8-1,IF(U8>40,T8-2,IF($CH8="shots back blocked",T8)))))))))))

The formula above is in Column "V" and should respond to information from columns "T" and "U" only. However, when the data in T and U is provided it changes columns R P & N in error. I can not work out for the life of me why this is happening. R P and N should not be affected.

Is there an error in the formula? If there is I can't find it.

Please help
Thanks
Robert

 

[awoohaw]

Okay, how about providing a small real world solution. Maybe 4 or 5 records, and 5 or 6 rounds of golf.
Then give expected results that you calculate manually. And maybe description of what is happening with each column of calculations on that sample.

Or post a mini sheet as I asked earlier, if you can. I understand some folks cannot. But this seems to be a non commercial question so you should be able to install add ins on your home computer.

 

[The Shadowman]

The add-in doesn't seem to be available to me. I tried to post a table, but when I tried to export it, it said something like "no internet connection". So can I show what you need as a screenshot?

 

[The Shadowman]

I thought it might help to see the whole thing

 

[awoohaw]

The add-in doesn't seem to be available to me. I tried to post a table, but when I tried to export it, it said something like "no internet connection". So can I show what you need as a screenshot?

why export? Images while helpful mean the forum must recreate your data scenario completely. Formulas can get copied wrong.
Please help the forum help you.

Paste as table:
Highlight the cells, click copy, come to the forum, start a post, and right click Paste. you've just posted as table. (Be sure to label the columns though).
Also paste the formulas.

You can also share a workbook to dropbox or some other well known reputable sharing service (onedrive as well).

 

[awoohaw]

I thought it might help to see the whole thing

I think you only need to post enough information to get to a solution. If the "shots back blocked" can only happen 3 times, then you only need 4 ROUNDS. And I'd suggest a number of different players so that all the various scoring scenarios can be managed.

Also, expected results need to be provided.

 

[The Shadowman]

Please help me here. If I do a table and post it how do I Label the columns and show formulas. Sorry, but I'm really only a novice

 

[awoohaw]

Please help me here. If I do a table and post it how do I Label the columns and show formulas. Sorry, but I'm really only a novice

type the letter of the column above each column, so in ROW7, type the column letters.
OR: Just tell us what cell is the top left cell of the table that you highlighted. And no hidden columns.
For formulas: below the table paste the cell address and formula. If the FORMULATEXT() function is available in 2019, that is a great tool for this. In an unused row you can show the formulas in row 8 like this... Assume ROW15 is not used.
start in cell V15 or the column that first has formulas (I think you wrote column V). , and put this formula,

=ADDRESS(Row(V8),COLUMN(V8),4) & ":  " & FORMULATEXT(V8)

(the function maybe TEXTFORMULA(), but I hope you understand what I'm asking).

If you don't have formula text in your version then you have to cut and paste the formulas from edit mode in the cells and also type the cell address.

Paste starting in V6

V

4​

V8: =2+2

Book1
	V
6
7	V
8	4
9
10
11
12
13
14
15	V8: =2+2
Sheet1

Cell Formulas
Range	Formula
V8	V8	=2+2
V15	V15	=ADDRESS(ROW(V8),COLUMN(V8),4) &": " & FORMULATEXT(V8)

 

[The Shadowman]

Column O	Column P	Column Q	Column R	Column S	Column T	Column U	Column V
40	22​	35	22​	33	23​	36	23​
32	18​	25	19​	33	20​	39	19​
DNP	13​	DNP	13​	34	13​	DNP	13​
39	18​	24	19​	33	20​	42	18​
24	22​	DNP	22​	28	22​	DNP	22​
36	8​	31	9​	38	8​	36	8​
35	11​	30	12​	29	13​	32	12​

 

[The Shadowman]

Rows 6-12

This formula in columns P R T U adjusted as per row
=IF(U15<34,T15+1,IF(U15="dnp",T15,IF(U15=34,T15,IF(U15=35,T15,IF(U15=36,T15,IF(U15=37,T15,IF(U15=38,T15-1,IF(U15=39,T15-1,IF(U15=40,T15-1,IF(U15>40,T15-2,IF($CH15="shots back blocked",T15)))))))))))

 

[The Shadowman]

Attached is an image of the whole thing which MAY give you a better idea