New Posts For Thread: Spreadsheet help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23468566/spreadsheet-help-pleaseHow do you put a fixed cell into a formula?I've got = (D3-B3)*J6 and I want all formulas as we go down the column to read (D4-B4)*J6(D5-B5)*J6(D6-B6)*J6(D7-B7)*J6etc....i.e. I want the row in each formula to go up by one, but the J6 to say the same rBrilliantthank youhttps://community.betfair.com/general_betting/go/thread/view/94082/23468566/spreadsheet-help-please?post_id=419140666#419140666Brilliantthank youWed, 11 Nov 2009 06:30:56 -0600put $J$6 as the cell.The $ fixes the following row/column reference.https://community.betfair.com/general_betting/go/thread/view/94082/23468566/spreadsheet-help-please?post_id=419140662#419140662put $J$6 as the cell.The $ fixes the following row/column reference.Wed, 11 Nov 2009 06:26:01 -0600How do you put a fixed cell into a formula?I've got = (D3-B3)*J6 and I want all formulas as we go down the column to read (D4-B4)*J6(D5-B5)*J6(D6-B6)*J6(D7-B7)*J6etc....i.e. I want the row in each formula to go up by one, but the J6 to say the same rhttps://community.betfair.com/general_betting/go/thread/view/94082/23468566/spreadsheet-help-please?post_id=419140658#419140658How do you put a fixed cell into a formula?I've got = (D3-B3)*J6 and I want all formulas as we go down the column to read (D4-B4)*J6(D5-B5)*J6(D6-B6)*J6(D7-B7)*J6etc....i.e. I want the row in each formula to go up by one, but the J6 to say the same rWed, 11 Nov 2009 06:24:39 -0600