50%

Dear Excel fellows: I want formula in Column C to E based on the percentage of column A on the quantity available in B, please help <colgroup><col width="184" style="width: 138pt; mso-width-source: userset; mso-width-alt: 6729;"> <col width="84" style="width: 63pt; mso-width-source: userset...

Hi all. I have a fairly complicated question and I've been racking my brain for a while. I have the following data set: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 146px"><col width="79"><col width="83"><col...

<tbody> <tbody> +A (66.05%) </tbody> <tbody> F (1.85%) </tbody> <tbody> A (25.83%) </tbody> <tbody> B (6.64%) </tbody> <tbody> G (11.07%) </tbody> <tbody> +G (66.79%) </tbody> +F (47.23%) A (4.8%) B (30.63%) </tbody> I have a huge spreadsheet with test...

Hello! I'm trying to bend Excel to my will but it refuses. Here's an example of my data set: <tbody> Date Name 1/4/18 Mary 1/4/18 Mary 1/4/18 Mary 1/5/18 Fred 1/6/18 Mary 1/6/18 Mary 1/7/18 Fred </tbody> Each date is a day someone worked. Each name is the name of the person...

Hello Please I need a help to make the following formula in cell H2: https://www.dropbox.com/s/4lbuh0b07zdtand/Untitled.png?dl=0 If D2 = "In Progress" and F2 is less than 50% of E2 then H2=(E2*50%)-F2 (Value if false = 0) and IF D2 = "Closed" and G2 is greater than zero then H2=G2 (Value if...

Could use some help – I tried to simplify this down to explain I am using powerpivot and have three different types of fruits. I have set up measures to total the fruit, but I need to create a calculated column that determines what % of the quantity of each fruit is on each line The bolded...

I am trying to rank the percentages in column A in column B. Since 200% is the highest, it would be ranked #1 . Can someone help? Thank you. <tbody> Column A Column B 200% 1 10% 2 50% 3 87% 2 </tbody>

Hello, I'm completely new to VBA i'm trying to get a set of indicators at the first available column in every sheet that the workbook contains. the column that is used for the verification is in percentage I have tried it with the macro recorder and several other things but I can't get it...

Hi i have this table for a timesheet with the following formula: <tbody> H I J K Day In Out Formula OT 25% OT 25% Formula OT 50% OT 50% 1 8 17 =SI(I3>=19.1,"3",(I3-H3-9)) 0 =(I3-H3-9-J3) 0 2 8 19 =SI(I3>=19.1,"3",(I3-H3-9)) 2 =(I3-H3-9-J3) 0 3 8 21 =SI(I3>=19.1,"3",(I3-H3-9)) 2...

Hello, I am looking for a formula to add 100% of the largest number or sets of that number with 50% of the second largest number or sets of that number. For instance, the following numbers may be in cells 12 35 14 14 6 14 So the formula will first see 35 is the biggest number, and there is...

Hi, Sorry if this is trivial, but I can't internet search this properly cause it is difficult to explain my question to a search engine :( I am working on a capacity planning spreadsheet. If can do 100 units of work, but I know that if someone assigns me 100 units of work but it may be 50%...

Hi I'm having hard time figuring out how to auto calculate the following in excel <tbody> From To Total 12% 50% 23:00 07:00 8 2 6 15:00 23:00 8 8 0 </tbody> So this is a work timetable where we get 12% extra if it's between 06:00 and 24:00 We get 50% extra for the time between 24:00 and...