Multiplying values is one of the most frequently performed functions in Excel, so it should be no surprise that there are several ways to do this. You can use whichever method is best suited to ...
Excel makes this easy too. Suppose you want to multiply all the values in column B by 10. In the C column, type the formula ...
What is Math and Trig functions in Excel? In Microsoft Excel ... If your argument is in the degrees multiply by PI()/180 or use the Radian function to convert it to radians.
I typed this formula into C2: =IF(ISBLANK(B2),"Data required",B2*7) because I wanted Excel to work out whether cell B2 was blank, and either return "Data required" (if B2 was blank) or multiply ...