divide

<tbody> I am trying to write a formula to calculate cost per foot (cell E13) I want the total in cell E12 to be divided by cell C8 if it has data if not move to cell C9, do this through C11. Item Quantity Cost Total Corner post assembly 8 90 720 "H" assembly 10 56 560 Wood...

ColA ColB 4 1 3 2 2 3 5 3 2 3 1 2 A20 B20 17 14 Sum ColA and Multiply by 3 (17*3) = 51 Sum ColB and Multiply by 2 (14*2) = 28 Then I need to add those 2 values (51+28) and...

Hi, I hv some amount like 25000. and I want to divide it on 9 employee. It show result in point like 2777.78 I want result without points. Like if I give 2778 to 7 person and 2777 to other 2 person. with this I can easily divide amount on all 9 employee. if there is any formula which I can...

I have 2 Arrays each located in a cell. I would like to divide the first one by the second one. Please see below. <tbody> Array {0;1;0;1;0;0;1} {0;1;2;2;0;1;2} </tbody> <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ...

Hi, I need a formula in column C to divide the number in C9 by the count of numbers in column B. There are 6 cells with numbers in column B, so it would be 41/6. I only want the result to be two decimal numbers and it has to equal the number in C9. Since 41 cannot be divided evenly, some...

Hello, I will do my best to explain what I am looking to do. 1) Column A has a person's name 2) The top columns have all 50 states 3) The states that the people have licenses in will have an "x" in them. So it would look something like this <tbody> CA AZ FL OR NV Betty Sue X X X...

I have a column of values: 460,683 441,249 107,800 89,406 I need a formula in another column that will tell me what value of 100 is needed to divide by in order to have the calculated result be <= 55% For example, the 460,683 can be divided by 900 and multiplied by .1 to equal 51%. I need a...

Hi, Can someone help with the below formula? Thanks <tbody> If less than 42 carton = 1 and divide greater than 42 carton, divide by 42 to get number of pallets required. Cartons Per Pallet #FFE699[/URL] , align: center"]42 Less than 42 #FFE699[/URL] , align...

Hi I'm trying to use Pivot table result in a formula. But result is getting only with the first cell. For Eg: 1100 1000 2550 4000 are my pivot table result. Let say sum of quantities. When I'm trying to divide this with 100, getting 11 as result in all the corresponding columns. Please help

Hi every one, i am newly registered but have been a vivid follower of this forum since last couple of year. Can anyone write a short code as i need to divide range of cells by 1000 but exclude blank and formula cells ? Any help will be highly appreciated.

Hi, I have an excel sheet with very large number of data. I want to use macro to divide the cells with value greater than 2. Is this possible?

Good day all, I have customers that need to be picked up every few days, sometimes a large package and sometimes a small package, the type of package is known at the beginning of the year. Is there a possibility to automatically divide this over the year? For instance: Client1: has at the...

Hi I wanted to know if there is a formula to average the cells from D5 to D9 if value is inside. So lets say D5 D6 D7 have values 100 50 50. Then it would divide the total 200 into 3, but if Value was in all cells D5 D6 D7 D8 D9 like 100 50 50 40 and 30. Then it would divide it into 5. Any...

Hi Can someone help me with VBA code to divide a long vertical string into horizontal strings that are 13 characters long and separated by comma. Each string shall begin with an E. The vertical string is in column A and may be different long, the result shall be written in column C. /Bilbon...

Hi, I'm trying to get my head around building this into our finances sheet and not sure where to start. What I want to do is have something like this https://www.calculators.org/budget/ - I want to specify a accounts with percentages and want to specify say a surplus of cash, and then divide...

Hello, I'm trying to do two formulas on a spreadsheet, both of which involve a fixed cell location (B8) and a variable cell location (depending on how many rows are generated each time). The first formula is a simple sum of all the columns from C onward for that row that I want to copy down to...

I need to see if I can get Excel to recognize a letter in a cell to mean a specific formula when it sees it in that particular cell. Here's what I am talking about: I want it to see the letter Q in the cell to know that it is suppose to divide the number by 3, when I put the letter A in the...

Hi all, I'm looking for a vba solution that finds the last cell in column Q and divides it by the last cell in column N. The last cells in column Q & N have sums for each column. I would then like to return this value in the last empty cell in column P. I know how to find the last cells in a...

Hi I can't get this to work into 1 cell. Here are the 3 parts. MAX(A572:A591)-MIN(A572:A591) (A572)-MAX(A572:A591) then I want to divide both like this (A572)-MAX(A572:A591)/MAX(A572:A591)-MIN(A572:A591) What am I missing, any suggestions? Thx!

Hello. Is there a way to do the following: I have a 'data entry' section in cells A1:A10 (so 10 cells). Sometimes I enter figures into all 10 cells, sometimes just a few. I want cell A11 to add up all entries in A1:A10, and then divide the total by how many entries there were in the range...