Really simple question: subtract and divide

V

ValleyDoc

I'm a beginner. How do I subtract and divide cells. I know the sum and
product functions for addition and multiplication.
 
A

Alan

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)
 
J

JE McGimpsey

One way:

A1: 15
A2: 3

To subtract:

B1: =A1 - A2

resulting in 12. To divide:

B2: = A1/A2

resulting in 5.
 
V

ValleyDoc

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?
 

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

Getting the formula right 5
VBA multiple list of values for variable 1
Need a little math help in making a formula 2
I'm sure its an easy answer.... 1
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Dividing after a long formula 5
Sum and Percentage Question... 2
How to divide numbers in Excel? 0

Top