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

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)


"Carole" wrote:

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

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


"Carole" wrote in message
...
I am trying to divide on an excel spread sheet, I forgot the formula, can
someone help?

No need for the SUM bit. =A3/A4 will suffice

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Blade" wrote in message
...
Hi Carole,
If you are wanting to divide cell A3 by cell A4
Try =SUM(A3/A4)


"Carole" wrote:

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