division

Hello! Im confusing how to join two formula in excel at once as what Mr AlanY did like this so PLEASE! I need an help. Basically Im grading the student who is taking combination of three subjects, with TWO criteria By considering weight of points as in table below shows; By DIVISION without...

Hi all, I want to create a formula that will search the amount of a product in a division for the closest date given. So, for the 2 images link, if I want to know the amount for Cakes in division 161 the nearest to the December 2nd, it would be 3.50$. https://imageshack.com/i/pmP1dYlLj...

The formula =SUMPRODUCT((Sched[Home]=[@Club])*(Sched[hScore]>Sched[vScore])+(Sched[VIS]=[@Club])*(Sched[vScore]>Sched[hScore])) is placed in the "W" column and it totals the numer of wins for that team in the table shown below Rank Club GP W L Percentage Rank Pts 4 Team A...

I have a workbook (A) that contains multiple tabs, where each needs to be linked to an external workbook (B) that also contains the division revenue on multiple tabs (Dallas, Houston, etc). In workbook A, the user will select a division (Dallas for example), which will look up the corresponding...

Hi I have two slicers one called Organisation and the other called Division. When I filter based on Organisation the Division list does not change and shows all divisions and does not filter just the divisions that relate to the Organisation. I have used the below measure but this does not...

I have a huge excel spreadsheet that I have inherited through an acquisition. 32,000 rows with 10 columns. I would like to count some dollar amounts in column "K" based on a vendor name in column "F and a division name listed in column "E". For example if I wanted to know how much money, from...

I need to write a formula that will do this: IF CELL1is <3000 AND CELL2 is <250 display "SMB" **its this second part that I cant really figure out all to well** IF (CELL1 is >=3000 but <15000) Divided by 4 is greater than CELL2 which is between 250 - 3000 is TRUE display "Multi-Family", FALSE...

i have two tables (not Excel tables, but data in a table format) like this: Imgur: The most awesome images on the Internet i'd like to divide table "part" with table "whole", so that i get the percentages like this: Imgur: The most awesome images on the Internet there is no extreme formula...

Hello all....I need to know how to perform math on query results...Here's what im looking at in the query Area1 3 8 Area2 4 8 Area3 5 8 Area4 2 8 Now here's what I need it to do, firstly add up the first column Area1 3 8 Area2 4 8 Area3 5 8...

Hi, I have two values: like A= 783 and B = 16272 seconds I want to calculate number of A in per seconds like (783/16272) a/seconds. So I use (A/B). but the result shows= 01:09:18. Please suggest me what should I do.Thanks

I have been tasked with creating a pivot table that illustrates what percent of employees in each department have completed Lesson A, which was assigned to them via our Learning Management System (LMS). The LMS spits out a report that lists each assigned person on a separate row. The last 2...

Hi, I hope all is well. Im doing my head in with the following expression: Range("i" & varRowForBudgets).Formula = "=g "& varRowForBudgets&"/ g "& varRowForBudgets+10&"" Range("i" & varRowForBudgets).NumberFormat = "0.00%" varRowForBudgets is currently 2000, replacing on the above: I want...

I'm Trying To Crate A Simple Division Formula I have 2 columns of numbers going down a page like this. Column A...........Column B 4...........................> I need the 4 to be divided by 50% to give and answer in Column B as (2) 1...........................> I need...

I have a cell, A18, that contains a cumulative total of units sold. I have another cell that I want to calculate the # of cases I'll need to order, based on the fact that there are 6 units per case. The formula I have now is =A18/6. However, it isn't calculating partials. For instance, if my...