Spreadsheet: 724849d1616419402-find-first-cell-that-reach-a-specific-value-either-its-positive-or-negative-sample-data
Sheet: Sample Data

 | PLUS VALUE | MINUS VALUE | START VALUE | 1ST REACHED | 2ND REACHED |  | VALUE TO REACH: |  | 280
 | 9300 | 9180 | 9200 | 280 | -280 |  | NOTES:
 | 9320 | 9200 |  |  |  |  | FOR THE 1ST REACHED, THE STARTING VALUE IS IN CELL D5, WHICH IS 9200.
 | 9400 | 9220 |  |  |  |  | VALUE TO BE REACHED IS IN CELL J2, WHICH IS 280.
 | 9500 | 9380
 | 9550 | 9150 |  |  |  |  | NOW IN CELL E5 I NEED A FORMULA TO FIND WHICH ONE THAT BE REACHED FIRST AFTER THE STARTING VALUE IN CELL D5. IS IT +280 FROM THE VALUES IN COLUMN B6 TO B13 OR -280 FROM THE VALUES IN COLUMN C6 TO C13.
 | 9800 | 8970 |  |  |  |  | 280 | IT'S +280 BECAUSE AFTER STARTING VALUE IN CELL D5, THE FIRST VALUE THAT BE REACHED IS 9500 IN CELL B8, WHICH IS MORE THAN 9480 FROM START VALUE (9200) + VALUE TO REACH (280).
 | 9130 | 9000
 | 9100 | 8820
 | 8990 | 8900 |  |  |  |  | NOTES:
 |  |  |  |  |  |  | FOR THE 2ND REACHED, THE STARTING VALUE IS IN CELL D5 + E5, WHICH IS 9200 + 280 = 9480.
 |  |  |  |  |  |  | VALUE TO BE REACHED IS IN CELL J2, WHICH IS 280.
 |  |  |  |  |  |  | THEN IN CELL F5 I NEED ANOTHER FORMULA TO FIND WHICH ONE THAT BE REACHED FIRST AFTER THE STARTING VALUE IN CELL D5 + E5, WHICH IS 9200 + 280 = 9480. IS IT +280 FROM THE VALUES IN COLUMN B8 TO B13 OR -280 FROM THE VALUES IN COLUMN C8 TO C13.
 |  |  |  |  |  |  | -280 | IT'S -280 BECAUSE AFTER THE STARTING VALUE IN CELL D5 + E5, WHICH IS 9200 + 280 = 9480, THE FIRST VALUE THAT BE REACHED IS 9150 IN CELL C9, WHICH IS LESS THAN 9200 FROM START VALUE (9480) - VALUE TO REACH (280).
 | IF THE FORMULA IN CELL E5 AD F5 APPLIED TO THESE DATA, IT SHOULD WORK LIKE THIS:
 | 9300 | 9180 | 9200 | -280 | 280 |  | -280 | IT'S -280 BECAUSE AFTER STARTING VALUE IN CELL [NAME], THE FIRST VALUE THAT BE REACHED IS 8900 IN CELL C25, WHICH IS LESS THAN 8920 FROM START VALUE (9200) - VALUE TO REACH (280).
 | 9320 | 8900 |  |  |  |  | 280 | IT'S +280 BECAUSE AFTER THE STARTING VALUE IN CELL [NAME], WHICH IS 9200 + (-280) = 8920, THE FIRST VALUE THAT BE REACHED IS 9400 IN CELL B26, WHICH IS MORE THAN 9200 FROM START VALUE (8920) + VALUE TO REACH (280).
 | 9400 | 9220
 | 9500 | 9380
 | 9550 | 9150
 | 9800 | 8970
 | 9130 | 9000
 | 9100 | 8820
 | 8990 | 8900
 | IF THE FORMULA IN CELL E5 AD F5 APPLIED TO THESE DATA, IT SHOULD WORK LIKE THIS:
 | 9300 | 9180 | 9200 | 280 | ERROR |  | 280 | IT'S +280 BECAUSE AFTER STARTING VALUE IN CELL D38, THE FIRST VALUE THAT BE REACHED IS 9500 IN CELL B41, WHICH IS MORE THAN 9480 FROM START VALUE (9200) - VALUE TO REACH (280).
 | 9320 | 9200 |  |  |  |  | ERROR | IT'S ERROR BECAUSE AFTER THE STARTING VALUE IN CELL D38 + E38, WHICH IS 9200 + 280 = 9480, BOTH +280 AND -280 ARE REACHED IN SAME LINE WHICH IS 9800 IN CELL B42 AND 9200 IN CELL C42.
 | 9400 | 9220
 | 9500 | 9380
 | 9800 | 9200
 | 9800 | 8970
 | 9130 | 9000
 | 9100 | 8820
 | 8990 | 8900
 | IF THE FORMULA IN CELL E5 AD F5 APPLIED TO THESE DATA, IT SHOULD WORK LIKE THIS:
 | 9300 | 9180 | 9200 | ERROR | ERROR |  | ERROR | IT'S ERROR BECAUSE AFTER STARTING VALUE IN CELL D52, BOTH +280 AND -280 ARE REACHED IN SAME LINE WHICH IS 9500 IN CELL B55 AND 8900 IN CELL C55.
 | 9320 | 9200 |  |  |  |  | ERROR | IT'S ERROR BECAUSE THE CALCULATION OF STARTING VALUE IN CELL D52 + E52 IS ERROR, WHICH IS 9200 + ERROR = ERROR.
 | 9400 | 9220
 | 9500 | 8900
 | 9550 | 9150
 | 9800 | 8970
 | 9130 | 9000
 | 9100 | 8820
 | 8990 | 8900