Newbie Excel 2000 Multiplication Formula Question

Home Forums Office Office XP / 2003 General Issues Newbie Excel 2000 Multiplication Formula Question

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Avatar
    thenoo
    Member
    #128218

    I would like to have an excel spreadsheet in which two of the columns are related in such a way that any number entered in , say column A , will be multiplied by 6.25 and the result appear in the same row in , say column B.

    I’ve tried several combinations for inserting formula in column B such as ” =A1*6.25 ” but all this seems to do is work for an entry in cell A1 but not in the subsequent entries in A2,A3 ,A4….etc.
    I thought these formulae changed when the rows changed .

    Oviously I’ve misunderstood something basic here – any help would be appreciated.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.