Try...
Code:
----B---- C D E ----F----
75 +1279 + 1 87 Months
76 +1290
F75
=(SUM((TRIM(MID(SUBSTITUTE(B75,"+",REPT(" ",255)),1+(ROW($A$1:$A$200)-1)*255,255)) & "0")/10)+(B76+0))/29.5306
IMPORTANT- This is an array formula
- Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
- If entered correctly, the formula will be enclosed in {brackets}
- Do not enter the {brackets} manually
Custom Format >> F75- Right click cell (or Ctrl + 1)
- Format Cells
- Number
- Custom
- Type: 0" Months"
Quote:
Also, I need to fill down the "F" column so that this formula keeps repeating adjacent to its respective cells in "B" column.
|
If the current values are in B75 and B76 with the result in F75, where are the next values, B77 and B78?
If so, you can just copy F75 and paste into F77.
How far down do you need to copy? How many results did you need?