Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assistance in modifying a formula
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with modifying a formula. | Excel Programming | |||
Modifying Formula | New Users to Excel | |||
Modifying a Formula | Excel Discussion (Misc queries) | |||
Help Modifying this Formula .... | New Users to Excel | |||
Modifying A Formula | Excel Worksheet Functions |