| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I Divide "/" a row of cells by another row of cells?
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I Divide "/" a row of cells by another row of cells?
In cell O6 enter:
=N6/M6 Copy O6 from O7 thru O20 -- Gary's Student "oxicottin" wrote: 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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I Divide "/" a row of cells by another row of cells?
=SUM(IF(M6:M20<"",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) "oxicottin" wrote in message ... 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!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I Divide "/" a row of cells by another row of cells?
the formula =SUM(IF(M6:M20<"",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. "oxicottin" wrote: 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!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I Divide "/" a row of cells by another row of cells?
Did you array enter it like I said?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "oxicottin" wrote in message ... the formula =SUM(IF(M6:M20<"",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. "oxicottin" wrote: 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!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I Divide "/" a row of cells by another row of cells?
Yes it says not valid in merged cells but i have no merged cells in that area?
"Bob Phillips" wrote: Did you array enter it like I said? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "oxicottin" wrote in message ... the formula =SUM(IF(M6:M20<"",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. "oxicottin" wrote: 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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
| Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
