answersLogoWhite

0

A formula in Excel must start with the = symbol. The asterisk (*) is used for the multiplication symbol and the forward slash (/) is used for division, so =12*2 would give the result 24 and =12/2 would give the result 6. =2+6*12 would give the result 74, NOT 96, because multiplication and division are calculated before addition and subtraction.

You are more likely to want to perform calculations that use values that have already been entered into worksheet cells. Imagine that cell C11 contains the number of hours worked on a particular job and cell C12 contains the hourly rate of pay. You want to calculate how much is owed for work on that project in cell D12, so in that cell you would enter the formula =C11*C12.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


What happens when you change a number within a sum formula in Microsoft Excel?

It can change a total that the formula results in.


What is the Excel formula to calculate the total of values in cells d7 through e20?

=SUM(D7:E20)


To calculate the sum of all the cells from E1 to E11 you would write the following formula in excel?

In another cell, you would type in =SUM(E1:E11)


How do you calculate the enthalpy change of a reaction (H) using the formula?

To calculate the enthalpy change of a reaction (H) using the formula, you subtract the sum of the enthalpies of the reactants from the sum of the enthalpies of the products. This formula is represented as H H(products) - H(reactants).


What do you need in a excel cell to calculate a sum?

You need a formula. That formula can use the Sum function or it could use the plus sign, or several plus signs and even several Sum functions. Primarily it is the Sum function and the plus sign that is used for sums.


Why sum format in excel does not detect cell change?

I need more detail in order to fully answer your question. Are you sure the sum formula includes the cells that you are changing?


How do you display Sales Amt on Excel 2013?

You would calculate it using the Sum function. It will depend on what cells your values are in as to what form the actual formula will take.


What are some examples of Excel formulas?

formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)


A calculation used in excell?

Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update when you open Excel or requires to you click the calculate button every time you want to see results.


Which formula in excel can i use to find the total cost of items?

The "Sum" formula works best.


What is an ict formula?

an ict formula is something that can caluculate a sum faster than usuall, it will work out the sum ,, and the software that is used is Microsoft excel.