View Single Post
 
Old 01-14-2017, 07:09 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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?
Reply With Quote