If you included cell A1 the header in the Sum Function. Things to Remember Formula with Text in Excel We can add the text values according to our preferences either by using the CONCATENATE function in excel or ampersand symbol. The formula below subtracts the value in cell A2 and the value in cell A3 from the value in cell A1.
Note the formula in the formula bar while the result we would expect is in cell B2.
Number 1 is subtracted by the percentage discount. Select the cell formulas you want to add to and click Kutools More Convert Refers. The MONTH function returns 6 then adds 7 to it from cell C2. First Excel will calculate the formula 1-C2.