Assistance in modifying a formula

C

Colin Hayes

Hi

I need some help in modifying a formula.

This is the formula in F2:

="Interval "&TEXT(F18,"0.00") &" Mins - " &TEXT(I18,"0.00") & " Miles "

I need the first column F reference to be dependant on the content of
0.0 in the cells H4:H18.

For example , if the first cell in H4:H18 with 0.0 is H14 , then the F18
reference in the formula would change to F14.

Example :

Row F G H I

4 0.00 2.00 1.5 0.05
5 2.00 2.00 2.5 0.13
6 4.00 2.00 3.5 0.25
7 6.00 3.00 4.5 0.48
8 9.00 2.00 5.0 0.64
9 11.00 2.00 6.0 0.84
10 13.00 2.00 5.0 1.01
11 15.00 3.00 4.5 1.23
12 18.00 2.00 4.0 1.37
13 20.00 2.00 3.5 1.48
14 22.00 2.00 0.0 1.57
15 24.00 1.00 0.0 1.59
16 25.00 2.00 0.0 1.59
17 27.00 2.00 0.0 1.59
18 29.00 2.00 0.0 1.59

In this case , because the first cell with 0.00 in column H is H14 ,
the formula would reference the content of F14 :

="Interval "&TEXT(F14,"0.00") &" Mins - " &TEXT(I18,"0.00") & " Miles "


Grateful for any advice.
 
Top