How do I divide, what would the formula look like? I forgot. Than.

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

Guest

I am trying to divide on an excel spread sheet, I forgot the formula, can
someone help?
 
Hi Carole,
If you are wanting to divide cell A3 by cell A4
Try =SUM(A3/A4)
 
Hi

With dividend and divisor p.e. in A1 and A2
=A1/A2

Or, to avoid error when dividing with 0
=IF(A2=0,"",A1/A2)

Or, to prevent calculations too, when either dividend or divisor cell is
empty
=IF(OR(A1="",A2="",A2=0),"",A1/A2)


Arvi Laanemets
 
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

Divide two cells and if the number is negative display is as zero 2
Help with a formula 1
Excel Excel Formula to calculate economy of a bowler (Cricket) 2
Creating a formula for Hydraulics 3
Excel Average dates help 0
adding function to an existing formula 2
rounded # to correct # 3
Formula Question 5

Back
Top