I am trying to divide on an excel spread sheet, I forgot the formula, can someone help?
C Carole Feb 1, 2005 #1 I am trying to divide on an excel spread sheet, I forgot the formula, can someone help?
A Arvi Laanemets Feb 1, 2005 #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
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