software

I have a excel sheet that I want to divide two long rows of cell by each
other. I want to divide n6 through N20 / M6 through M20. In the N row I have
a percent and I want to divide it by Time in the M row. Please help!!

In cell O6 enter:

=N6/M6

Copy O6 from O7 thru O20
--
Gary's Studentquot;oxicottinquot; wrote:

gt; I have a excel sheet that I want to divide two long rows of cell by each
gt; other. I want to divide n6 through N20 / M6 through M20. In the N row I have
gt; a percent and I want to divide it by Time in the M row. Please help!!

=SUM(IF(M6:M20lt;gt;quot;quot;,N6:N20/M6:M20))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;oxicottinquot; gt; wrote in message
...
gt; I have a excel sheet that I want to divide two long rows of cell by each
gt; other. I want to divide n6 through N20 / M6 through M20. In the N row I
have
gt; a percent and I want to divide it by Time in the M row. Please help!!
the formula =SUM(IF(M6:M20lt;gt;quot;quot;,N6:N20/M6:M20)) didnt work it gave me a
#value. My boss explained what he wanted better to me let me try again. I
have a row that is cells K6 through K20 that are in a time format like 2:00.
I want to divide those cells by the cells M6 through M20 which are in a
percent format. Then I want to multiply the number i get by 100 to give me a
percent. what im using this for mabe it will help if i explain? We run
machines for a 8hr period or less which we call hours worked, cells M6-M20
sometimes the machines are down or not running in those hours which we call
delay time cells K6-K20 I needed a % that the machine was down for the amount
of hours worked.

quot;oxicottinquot; wrote:

gt; I have a excel sheet that I want to divide two long rows of cell by each
gt; other. I want to divide n6 through N20 / M6 through M20. In the N row I have
gt; a percent and I want to divide it by Time in the M row. Please help!!

Did you array enter it like I said?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;oxicottinquot; gt; wrote in message
...
gt; the formula =SUM(IF(M6:M20lt;gt;quot;quot;,N6:N20/M6:M20)) didnt work it gave me a
gt; #value. My boss explained what he wanted better to me let me try again. I
gt; have a row that is cells K6 through K20 that are in a time format like
2:00.
gt; I want to divide those cells by the cells M6 through M20 which are in a
gt; percent format. Then I want to multiply the number i get by 100 to give
me a
gt; percent. what im using this for mabe it will help if i explain? We run
gt; machines for a 8hr period or less which we call hours worked, cells M6-M20
gt; sometimes the machines are down or not running in those hours which we
call
gt; delay time cells K6-K20 I needed a % that the machine was down for the
amount
gt; of hours worked.
gt;
gt; quot;oxicottinquot; wrote:
gt;
gt; gt; I have a excel sheet that I want to divide two long rows of cell by each
gt; gt; other. I want to divide n6 through N20 / M6 through M20. In the N row I
have
gt; gt; a percent and I want to divide it by Time in the M row. Please help!!
Yes it says not valid in merged cells but i have no merged cells in that area?

quot;Bob Phillipsquot; wrote:

gt; Did you array enter it like I said?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;oxicottinquot; gt; wrote in message
gt; ...
gt; gt; the formula =SUM(IF(M6:M20lt;gt;quot;quot;,N6:N20/M6:M20)) didnt work it gave me a
gt; gt; #value. My boss explained what he wanted better to me let me try again. I
gt; gt; have a row that is cells K6 through K20 that are in a time format like
gt; 2:00.
gt; gt; I want to divide those cells by the cells M6 through M20 which are in a
gt; gt; percent format. Then I want to multiply the number i get by 100 to give
gt; me a
gt; gt; percent. what im using this for mabe it will help if i explain? We run
gt; gt; machines for a 8hr period or less which we call hours worked, cells M6-M20
gt; gt; sometimes the machines are down or not running in those hours which we
gt; call
gt; gt; delay time cells K6-K20 I needed a % that the machine was down for the
gt; amount
gt; gt; of hours worked.
gt; gt;
gt; gt; quot;oxicottinquot; wrote:
gt; gt;
gt; gt; gt; I have a excel sheet that I want to divide two long rows of cell by each
gt; gt; gt; other. I want to divide n6 through N20 / M6 through M20. In the N row I
gt; have
gt; gt; gt; a percent and I want to divide it by Time in the M row. Please help!!
gt;
gt;
gt;