if formula excel help

Hello, please help me with the formula for "ABC" column to get these answers with reference to column "Quantity %" & "% with Issue Value" when "Quantity %" & "% with Issue Value" both are greater than 1.5% - A when "Quantity %" & "% with Issue Value" any one is greater than 1.5% - A when...

I am beyond frustrated and my perfectionist nature won't let me give this one up and I know there are some geniuses here that can help me find a solution but I can't take another YouTube video or confusing tutorial. I have a data source that contains giving records, most records have 12 entries...

Within a set of time constraints, I am trying to create a formula that will allow me to identify IF a time is between two times, to assign it a text value. I would like to do this for multiple values. The data in M/N/O is the value set for output. Column J is my example of times to use. Column K...

Hello, I am trouble creating a formula to go into Cells B2:I2, Im trying to have Excel say Find the Text "Scheduled Date" match the date below with a date in Row 1 and provide the information in Column M for Test 1 , Only Information from the Text "Scheduled Date to Subtotal" Belongs to Test 1...

Im doing someones accounts and i need to use the IF FORMULA to work out the values, so between if there wage is between £5000 and £45000 that week (lets say) i want there wages to be charged at 7.5% VAT and it works out the values for me. So when it goes over £45+k i want it to be charged at 20%...

Hi All, I know what I am wanting to do but I can't find the right written expression to generate the results. What I wanting is column J to do the following: If F2>1 then D2 – F2 or if F2 is blank D2+E2*H2 Sample <!--StartFragment--> <colgroup><col width="65" span="10"...

Hi, I am a new excel user and can't figure out my IF formula. I'm trying to use this in an invoice for a vacation rental company.. I don't know what I am doing wrong... =IF(A1="HIGH",95,0)+IF(A1="APRIL",110,0)+IF(A1="LOW",80,0) I want it to do $95 for when the cell says HIGH, for high season...

Hi All, I need assistance witht he following formula: In cell O2 I am trying to display a "yes" if the number 3 populates any cell in colums M:M and N:N & a "no" for every other number and blanks Thanks Michael

Hello, I am working on a project where I need to split hours between departments. So for example if a shift was done from 7am to 7pm it would be coded to the department in Department 1 (column A). If it was worked from 7pm to 7am it would be coded to the department in Department 2 (column B)...

So basically I have a Month's data to collate. The data is sent daily on a workbook (Lets say that the spreadsheet follows the naming convention 2014-03-01, </SPAN>2014-03-02, 2014-03-03 etc) In the workbook, it contains a sheet that has columns and rows that are related. To help visualise...

Hi all I am trying to work out a formula for my below commission structure; £0.00 - £5,000 generated = 0% commission £5,000 - £10,000 = 15% commission £10,000 - £15,000 = 17.5% commission £15,000 - £20,000 = 20% commission £20,000 - £25,000 = 22.5% commission £25,000 + = 25% commission (so...

Hello Excel Gurus out there. I am trying to calculate premiums and I have the option of 7 Limits and 5 deductible options. I am trying to connect the IF section that correctly calculates the premium now but I want to add options for deductibles (C6). I tried...

Hi, I need help with an IF Formula J1 is the cell i need to change colour to green if Cell I1 is £0, i need it to be red if the cell I1 is more than £0 What is the Formula i need to type into J1? Any help would be appeciated...