min function

Hi Everyone, I made this account specifically to ask this (probably very simple) question. I have gone through quite a few websites trying to get an answer but I can't seem to find one that works. Standard time is Monday through Friday 7am to 6pm Overtime is anything outside of that, so...

Hello, I'm not sure if I'm asking my question correctly but hopefully I can make it clear. This is an example of my data: I have animal names, a distance in meters and a "closest" column, in which I need to display a "Y" next to the minimum distance of that group (so the minimum distance of...

In the below excel table I have two steps and am stuck on the second. My first, StepA, Apply attachment point,Total Value – Attachment Point. If result is less than zero, than the exposure to the policy = 0. (= IF(TotalVal – AttchPt < 0, 0, TotalVal – AttchPt)) For Step B - Apply Policy Limit...

I have a couple of data sets that I need to determine the minimum and maximum values. I have tried (and failed) to configure a formula that essentially says, IF Column A (Keys) contains "P:", then give me the minimum/maximum value of the corresponding value in Column B (Partial). The data sets...

Hi I have a function called getdates and getdates2 basicly they are you same function but folder Dir is different I want to get earliest date using min function Like =min (getdates, getdates2) will work fine if there is text file with specific date if no date found then it will return 0 When...

A am doing a queuing problem, with a single queue and multiple servers. I am currently looking for a function which will find the smallest number in a matrix and return the corresponding column number. I want to find the server to take on the next customer, so I need to find the lowest "end...

Hi there, I have a spreadsheet wherein I need to extract the minimum value from 4 Suppliers. The suppliers are colour coded, and i would like the extracted amount to show the suppliers colour code as well as the value. I am merely using currently the Min function. Can anyone assist me...

I's there a way to put this excel formula in the VBA sub below ? If(min(D3:d$4)>e2,min(d3:d$4)-e2,0) Cell d$4 is dynamic.....it could be 50 or 1000 I was thinking i could write a For Next statement like shown below in bold.....but I can't figure out how to write it for the min statement...

Hello, What I'm looking to do is compare 4 cells containing dollar values to determine the minimum value. The cell to the right of each should then either display the value of the original cell (immediately to its left) if it is the minimum of the 4 cells being compared or the difference...

I have a column of percentages, and need to highlight the smallest value that is greater than 80%. This report is updated daily. I would like to know how to set conditional formatting to do this, or at least have a formula or run a macro to do this.

I am trying to run a PivotTable that groups data by names with Dates, and then pull up the earliest time. The Min value function does not return any of the dates in my data. Dates/Times around 5/2/2012 7pm to 11pm returns 5/3/2016 at odd hours. Does anyone know what I can try? Thanks!

Suppose A1 comtains amount 30000 & in B1 the function should be applied that if the amount is more than 20000, the B1 should be 20000 otherwise A1. How to apply MIN function.

Search and combining row and column data <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have been working on this with one other guy for the majority of the day and wondering if anyone has any insight. <TABLE style="WIDTH: 319pt; BORDER-COLLAPSE...