cell with principal value> is the cell number of the cell containing the principal amount. <cell with rate ... The formula for simple interest in Excel is =<cell with principal value>*<cell ...