excel formula

Hi Friends, I need support on excel formula. I am using ageing calculation formula based on customer type. If it is Third party customer I need age buckets like >15 days, Not Due, Less than 15 days. and if it is Inter Company customer again >30 days, Not Due, less than 30 days.Row B has value...

Query : How Set Different Number to Different color Highlight (like a same number Group Show in same color) Number match perfect & Smart..........pleased Solve it Conditional...

Good day, I have this workbook with 3 sheets (Data, 1st and 2nd). In Data, i have a table with index match formulas to auto populate the values of each HBins (1~12). So far it was working for most of the time but then I found out that some search pattern I'm using were changing, hence...

I have excel sheet where certain values mentioned, here it's explained briefly so that it will be easy to understand the requirement symbol=stock name expiry date=time of contracts expire strike price= numerical value ce=call pe=put oi=open int. now, for every 1 strike price, there can be 2...

In air traffic control and I am making an aircraft log with aircraft's callsigns, type aircraft, departure times, arrival times etc. When working with times dealing with military aircraft, all times are in UTC time. NO local times ex. 9:00 P.M/21:00L more like 02:00 the next Julian date...

I am trying to write a formula based on the following conditions and it is not working IF A1 = "S", and B1 = 254 or 127, Use LIST NOLIST IF A1 = "F" or "M", and B1 = 254, and C1 is even, Use LIST EVEN254 IF A1 = "F" or "M", and B1 = 254, and C1 is odd, use LIST ODD254 IF A1 = "F" or "M", and...

I am looking for a help with a formula in excel. I have two tabs in my excel Updates: One: My input is in cell F1 When the input is 1, it should check if ID 1 is available in "updates" sheet and return a random "Code" from "updates Sheet" which has ID 1. IF ID 1 is not available in Updates...

Hello everyone I am looking to identify family members who are eligible for a benefit. Let's say govt. has identified a set of eligible fruits that qualify under benefits. If any family member sells one of those fruits, all family members become eligible for benefits. All family members are...

Kindly Find Result....in Above Question...

I am using this long IF statement to calculate the commission rate for sales people. The value if true portion works but the value if false returns FALSE in the cell instead of executing the false instruction which in this case is (IF(R11<1,(H11*($C$7/10000)),H11*R11). Maybe I cannot have...

Hello There, I want to copy the highlighted text from one column to other columns. There are two options. 1) Highlighted text is "BOLD" 2) Highlighted text is "COLORED" Ideal two separate solution each for "Bold" and "Color" If either of one is not possible then please give any one solution...

Hi All I have excel file under Role column i have (Maker,Checker and Supervisory) and under Activity list i perform, Now in sheet 2 i have predefined time . So i need formula if anyone selects either Maker or checker or supervisor respective time should come from sheet 2. Could you please help...

I do not know if this is possible however, what I am looking for is to modify this UDF function to show the date that a cell was last modified. Currently, it is only showing the date that the UDF is inserted, not the actual date that the cell was modified. For Example: -If I am insert the...

Hi! I am doing a stock rotation report for my Company which basically displays an Age Profile (How long since stock was created) of both Stock on the Ground and Stock Despatched in the past day. I would like to do a formula beside this table (Will attach image showing example) that returns the...

Hi everyone, Hoping I can get a bit of help on something I have a range of products that are supported and I want to ensure that I can make the cost of supporting these products as cost effective as possible. Different employees support a variety of different product, even multiples but for...

Hi all, First I want to apologize if my question lacks some formula knowledge, I'm new to this level of Excel and trying to figure this out. Second, I want to thank all for tolerating my ignorance. Here is my challange: I'm designing a stopgap solution for querying a large Excel spreadsheet...

Crosspost: A Proper Formula to Calculate depending several Criteria and A Proper Formula to Calculate depending several Criteria Linked File: EG7 Dear All, I wrote a formula in cell AB4 (blue row) of the linked file by checking sources on internet. However I transferred the required data in...

Hi, I have following cells: Original Value Adjusted Value A A A B B In column B, "Adjusted Value", I have the following formula in each cell to eliminate any duplicates in column A: =IF(A2=A1,"",A2) =IF(A3=A2,"",A3) =IF(A4=A3,"",A4) The problem occurs when I delete row 3 (the...

Hi all, Wondering if anyone could help with this? I'm looking for formula that gives me the answer to this question: If target achieved is 106%, commission paid is 50% with a liner progression to 100% with max target achieved of 125%. Actual achievement is 110%, what is the commission %? 106%...

Please help me that how can we repeat column B names (vamsi and suresh) until cell value = EOH12 (column A). A column I B column E0H11 vamsi E0H24 suresh E0H01 (Repeat here) E0H54 (Repeat here) EOH12 (Repeat...