Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to divide on an excel spread sheet, I forgot the formula, can
someone help? |
#2
![]() |
|||
|
|||
![]()
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? |
#3
![]() |
|||
|
|||
![]()
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? |
#4
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |