Really simple question: subtract and divide

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a beginner. How do I subtract and divide cells. I know the sum and
product functions for addition and multiplication.
 
Is equal to =(A1=A2)
Add =A1+A2
Subtract =A1-A2
Divide =A1/A2
Multiply =A1*A2
Is less than =A1<A2
Is less than or equal to =(A1<=A2)
Is More than =(A1>A2)
Is More than or equal to =(A1>=A2)
Is not equal to =(A1<>A2)
 
=A1-B1
=A1/B1

no need for sum, unless summing a range or a number of cells.
 
One way:

A1: 15
A2: 3

To subtract:

B1: =A1 - A2

resulting in 12. To divide:

B2: = A1/A2

resulting in 5.
 
I can't just write A1-B1 in a cell or it comes up as just "A1-B1". What else
do I need to do?
 
ALWAYS include the equals sign in front of any formula.
So it's =A1-B1, not A1-B1.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Need a little math help in making a formula 2
subtract and divide 1
Workday Formula to include date 0
Sum and Percentage Question... 2
Can't make the division work in my formula 3
excel 4

Back
Top