excel formula

Hi, Please help with formula or a method to calculate per employee job level salary cost for different departments when we only have is total salary cost employee for entire dept. We are also given average salary for each level of employee. Below are the details Average salary per Job level...

# How to sum with unique Invoice Number wise ????? - Pleased Solve this query for formula ......very usefully trick for sale bill fill. like single invoice & two or more products in this sheet... problem is how to sum product based on unique Invoice No. - Pleased Help !!!

Show Result : 3 (Pleased Show this Query........................................)

like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????

I have excel sheet, which has value stored as price in "D" column now, I want to highlight particular cell in column "D" which satisfies below 2 conditions XFB9<=0.02 which cell has highest value among cells that has fulfilled above condition (column "D") issue I find here in writing formula...

Hello guys, Need your help in getting the Excel Formula based on condition, 1. If Column A = Current Month and Column B > Current Month then Result in Column C is >MO 2. If Column A = Current Month and Column B = Current Month then Result in Column C is MO 3. Rest should be mentioned as Nill...

Hi, I have list of employees with their goals, each employee has at least 3 goals and each goal has a different update goal date. My question is how to figure out the most recent update date of each employee? What is the right formula? Below is a sample of employees list: EE ID Last...

I want to create a chart with two columns: one column will be my budget, the other column I want stacked to show what I have spent so far and what I expect to spend. I tried faking it by creating two charts (one for budget, the other for the stacked), but this can cause problems when the sum of...

Hello all, I'm looking for a formula for cell J5 that can calculate what the cost would be for the entire month of May based on the information below. I am hoping to make a formula that won't require to be updated even if there are new trips with new months, # of people, (The location will...

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...