divide

Hi Have a little issue and need a formula for below. If the word "Salary" is found in G4 divide H4 by 40 but if "Part Time" or "Casual" is found in G4 use value in H4. Any help would be great. Thanks Stephen

Hi, I am trying to figure out how to change a value in a cell using VBA in Excel...this would occur within the cell itself...if the value is >= 0.95, I want to divide the value by 1,000, if >= .095 and < .95, I want to divide the value by 100, and if >= .0095 and < .095, I want to divide by 10...

I could really use some help creating a macro. I am still a beginner when it comes to creating macros but I have managed to piece a couple together with the record function and making some tweaks here and there. But what I’m asking for is WAY over my head. What I’d like to create is a command...

Good afternoon all Dividing the below, when the result is greater than 8 add .5 to the divisor and then divide the dividend by the new divisor. <colgroup><col width="70" style="width:53pt"> <col width="86" style="width:65pt"> <col width="96" style="width:72pt"> </colgroup><tbody> 70.25...

In my script I have: MyStores = 160 Range("F1").Select If InStr(1, (Range("F1").Value), "aaa_") Then MySets = Application.RoundUp(MyStores / 8, 0) End If Range("F1").Select If InStr(1, (Range("F1").Value), "bbb_") Then MySets =...

I need a formula for E2 and F2 In E2, I need the sum of the amounts of February. Also, if Column B says "TEAM" then divide the amount by 2. So E2 total should be 450 because 200+200+(100/2) In F2, I need the sum of the amounts of March. Also, if Column B says "TEAM" then divide the amount by...

Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = Range("C43:E43") On Error GoTo ws_exit: If Not Intersect(Target, rng) Is Nothing Then Application.EnableEvents = False Target.Value = Target.Value / .50 End If ws_exit: Application.EnableEvents = True End Sub I've...

Hi all very new here. i have a list of products when i select one it has that products square footage and then i add in the customers..Example - customer has 132 sq ft, a pallet holds 120 sq ft, and a layer holds 12 sq ft I'm trying to get my sheet to resemble that in two different cells pallet...

hi why I can not insert a vertical boarder that will divide a cell vertically or inserting a horizontal boarder that will divide a cell horizontally. Both option are available when I go to Boarder-->more boarders. I can insert any other boarders except these 2. Why I can not and why they are...

Hi, I am looking for formula that divides in data or numbers into 40 rows and paste in new column. Example: ============ Column A 15248 2113547 2665478 265475 2546981 . . . Etc Like above example in Column"A" I have a list of numbers upto 200,000 (2 Lakh). Now I need this to divide after...

Have data in column A & B. Need to divide column B by column A in column C. The numbers are percentages and the range is dynamic may change. example <colgroup><col width="72" span="3" style="width:54pt"> </colgroup><tbody> 40 12 30.0% 35 11 31.4% 23 10 43.5%...

I know this is probably simple, but I'm trying to add two cells and then divide by another cell. So far I have this =a2+a3/a4 and it doesn't work.

https://drive.google.com/a/writingline.com/file/d/1TLHGZw3XuXqn3CkziIjqDFwhjeaccopc/view?usp=sharing Here you can see an example of what I want to achieve. Please let me know the simplest way to divide the value? Thanks

I could really use some help please. I don't know if it is even possible but I thought maybe someone here had some advice. I am using Excel 2013. I have created a tracker that has: a list of all personnel in my company going down column A. Going across the top row I have a number of different...

Hi, I have a pivot table in hours. I would like to convert it in days. Does anyone knows how to divide the pivot table data by a numerical character? Thanks! Edu

Hi everyone, Thank for coming in. I have product informations and would like to seperate into 5 bullet point like below. <tbody> Product Description BP1 BP2 BP3 Solid,durable,waterproof,rustless. A must-have tool for your car. Set you free from the danger by cutting the seat belt. You...

Trying to make this work. Trying to divide B6 cell into 2 then add B6 lets say B6 value is 50.78 trying to get 76.17 50.78 divided into 2 is 25.39 + 50.78 = to 76.17 =SUM(B6\B6)+(B6) Thanks

Hello, I would like to calculate the average of a range in a column, where the size of the average is to be determined by the value in a reference cell. For example, if A1 = 100, then the average calculated in B1 would sum B2:B101 and divide by 100; if A1 = 50, sum B2:B51 and divide by 50...

I have a pivot table with two running total columns. I would like to divide one column by the other to create a running average. After much searching I cannot find a way to do this. Simply creating a calculated field doesn't work. I was able to do this in Tableau a few years ago, but I'm not...