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

C

Carole

I am trying to divide on an excel spread sheet, I forgot the formula, can
someone help?
 
A

Arvi Laanemets

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
 

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

Top