Spreadsheet: 29864d1225075945-if-and-offset-how-to-offset-only-if-cell-has-a-value-in-it-follows-previous-post-forum-question1
Sheet: Sheet1

user input A => | 3 |  |  |  |  |  |  |  |  |  |  |  |  | What I get based on the current formulae (note condition is not satisfied in columns S/T and U/V): |  |  |  |  |  |  |  |  |  | What I want (note difference in columns AC/AD and AE/AF):
user input B => | 4
user input C => | 3 |  |  | example A |  | example B |  | example C |  | example D |  |  |  | example A output |  | example B output |  | example C output |  | example D output |  |  |  | example A output |  | example B output |  | example C output |  | example D output
user input D => | 2 |  | time | input A | result A | input B | result B | input C | result C | input D | result D |  |  | time | result A | time | result B | time | result C | time | result D |  |  | time | result | time | result | time | result | time | result
 |  |  | 0 | 200 | 100 | 100 | 25 |  |  |  |  |  |  | 0 | 100 | 0 | 25 | 0 | 0 | 0 | 0 |  |  | 0 | 100 | 0 | 25 | 8 | 50 | 12 | 70
 |  |  | 1 |  | 70 |  | 24 |  |  |  |  |  |  | 3 | 125 | 4 | 25 |  |  |  |  |  |  | 3 | 125 | 4 | 25 | 11 | 50 | 14 | 70
 |  |  | 2 |  | 66 |  | 11 |  |  |  |  |  |  | 6 | 160 | 8 | 50 |  |  |  |  |  |  | 6 | 160 | 8 | 50 | 14 | 60 | 16 | 65
 |  |  | 3 | 200 | 125 |  | 56 |  |  |  |  |  |  | 9 | 125 | 12 | 55 |  |  |  |  |  |  | 9 | 125 | 12 | 55 | 17 | 100 | 18 | 60
 |  |  | 4 |  | 44 | 125 | 25 |  |  |  |  |  |  | 12 | 160 | 16 | 55 |  |  |  |  |  |  | 12 | 160 | 16 | 55 | 20 | 125 | 20 | 70
 |  |  | 5 |  | 125 |  | 45 |  |  |  |  |  |  | 15 | 225 | 20 | 75 |  |  |  |  |  |  | 15 | 225 | 20 | 75 | 23 | 100 | 22 | 75
 |  |  | 6 | 200 | 160 |  | 100 |  |  |  |  |  |  | 18 | 110 | 24 | 112 |  |  | 12 | 70 |  |  | 18 | 110 | 24 | 112 | 26 | 60 | 24 | 125
 |  |  | 7 |  | 54 |  | 124 |  |  |  |  |  |  | 21 | 105 | 28 | 125 |  |  | 14 | 70 |  |  | 21 | 105 | 28 | 125 | 29 | 60 | 26 | 135
 |  |  | 8 |  | 55 | 125 | 50 | 300 | 50 |  |  |  |  | 24 | 144 | 32 | 125 |  |  | 16 | 65 |  |  | 24 | 144 | 32 | 125 | 32 | 55 | 28 | 140
 |  |  | 9 | 100 | 125 |  | 66 |  | 50 |  |  |  |  | 27 | 109 | 36 | 75 |  |  | 18 | 60 |  |  | 27 | 90 | 36 | 75 | 35 | 50 | 30 | 60
 |  |  | 10 |  | 100 |  | 67 |  | 50 |  |  |  |  | 30 | 110 |  |  |  |  | 20 | 70 |  |  | 30 | 110 | 40 | 75 | 38 | 110 | 32 | 60
 |  |  | 11 |  | 100 |  | 90 | 300 | 50 |  |  |  |  | 33 | 112 |  |  |  |  | 22 | 75 |  |  | 33 | 112 | 44 | 100 | 41 | 100 | 34 | 60
 |  |  | 12 | 100 | 160 | 125 | 55 |  | 60 | 100 | 70 |  |  | 36 | 180 |  |  |  |  | 24 | 125 |  |  | 36 | 180 |  |  | 44 | 90 | 36 | 60
 |  |  | 13 |  | 45 |  | 66 |  | 50 |  | 70 |  |  | 39 | 180 |  |  |  |  | 26 | 135 |  |  | 39 | 180 |  |  |  |  | 38 | 45
 |  |  | 14 |  | 23 |  | 67 | 225 | 60 | 110 | 70 |  |  | 42 | 125 |  |  |  |  | 28 | 140 |  |  | 42 | 125
 |  |  | 15 | 100 | 225 |  | 90 |  | 100 |  | 78 |  |  | 45 | 100 |  |  |  |  | 30 | 60 |  |  | 45 | 100
 |  |  | 16 |  | 110 | 125 | 55 |  | 67 | 125 | 65 |  |  |  |  |  |  |  |  | 32 | 60
 |  |  | 17 |  | 11 |  | 24 | 200 | 100 |  | 89 |  |  |  |  |  |  |  |  | 34 | 60
 |  |  | 18 | 200 | 110 |  | 11 |  | 123 | 75 | 60 |  |  |  |  |  |  |  |  | 36 | 60
 |  |  | 19 |  | 109 |  | 56 |  | 145 |  | 90 |  |  |  |  |  |  |  |  | 38 | 45
 |  |  | 20 |  | 145 | 225 | 75 | 175 | 125 | 70 | 70
 |  |  | 21 | 125 | 105 |  | 45 |  | 67 |  | 100
 |  |  | 22 |  | 220 |  | 100 |  | 80 | 70 | 75
 |  |  | 23 |  | 123 |  | 124 | 150 | 100 |  | 100
 |  |  | 24 | 250 | 144 | 225 | 112 |  | 90 | 70 | 125
 |  |  | 25 |  | 23 |  | 200 |  | 78 |  | 124
 |  |  | 26 |  | 25 |  | 124 | 120 | 60 | 100 | 135
 |  |  | 27 | 88 | 109 |  | 34 |  | 100 |  | 56
 |  |  | 28 |  | 11 | 225 | 125 |  | 124 | 100 | 140
 |  |  | 29 |  | 46 |  | 37 | 110 | 60 |  | 55
 |  |  | 30 | 145 | 110 |  | 45 |  | 45 | 100 | 60
 |  |  | 31 |  | 45 |  | 67 |  | 45 |  | 67
 |  |  | 32 |  | 60 | 225 | 125 | 110 | 55 | 100 | 60
 |  |  | 33 | 122 | 112 |  | 24 |  | 55 |  | 78
 |  |  | 34 |  | 67 |  | 11 |  | 50 | 235 | 60
 |  |  | 35 |  | 78 |  | 56 | 100 | 50 |  | 78
 |  |  | 36 | 200 | 180 | 225 | 75 |  | 65 | 220 | 60
 |  |  | 37 |  | 56 |  |  |  | 100 |  | 90
 |  |  | 38 |  | 45 |  |  | 75 | 110 | 65 | 45
 |  |  | 39 | 200 | 180 |  |  |  | 100
 |  |  | 40 |  | 90 |  |  |  | 100
 |  |  | 41 |  | 91 |  |  | 50 | 100
 |  |  | 42 | 200 | 125 |  |  |  | 56
 |  |  | 43 |  | 110 |  |  |  | 45
 |  |  | 44 |  | 100 |  |  | 80 | 90
 |  |  | 45 | 150 | 100