formula =if()

I'm trying to nest multiple IF statements, along with IF(AND(OR) statements within one cell. The "Premium Table" I have to use is below, along with a sample of the the worksheet. The question is: What IF statement do I enter in cell D2 to obtain the correct premium? Premium Table Age Range -...

Hello Everyone, So I created a drop down menu with the days of the week on it. Now I want to be able to alter a cells data to read a time per each day. =IF(K21="Friday","4:00pm") This formula works and hypothetically I should just be able to repeat this a bunch of times but for some reason...

I am trying to join two datasets (csv format) by using conditional if statements. First dataset is accident information which does have a unique id (caseno) and the second dataset is roadway information which does not have a unique id. To join the accident file to the road file, I have to match...

I have a workbook where I input information in specific cells to create combinations to calculate employee bonuses. My workbook has 4 tabs: Data Bonus Base Bonus Summary The Data tab is formatted like this: <tbody> Column A Column B Column C IF formula below Base Salary? Employee...

I need a formula column M to reflect CRITICAL, CURRENT, FUTURE based on text and/ date range within column K. Column K <tbody> 1-Aug-2018 31-Oct-2012 31-Oct-2014 Ended 31-Oct-2020 31-Jun-2017 30-Oct-2017 None Announced 30-Mar-2018 TBD </tbody> If Column K contain...

Hi, I am attempting to use conditional formatting to highlight any cells in a column that meet certain criteria. Simply put, if the difference between cell one (a date) and cell two (a prior date) exceeds a certain number (the number of days between the two dates) I want that cell to be...

<tbody> A B C D E 1 LOCATION AMOUNT Mr. A Mr. B 2 LAS Mr. A $0 3 LAS Mr. B $10,000 4 LAS Total $10,000 5 LAS TV $2,000 $2,000 (manual input) 6 LAS Radio $8,000 $8,000 (manual input) 7 SFB Mr. A $2,500 =C7/C9 =C8/C9 8 SFB Mr. B $2,350 9 SFB Total $4,850 10 SFB TV...

I have a set of data which I need to sort based on some relatively simple criteria. The difficulty I am having is how to capture the interdepencies of the logic of the sort criteria. Written in plain English, I am trying to do the following. -If a record has an email address, categorise as...

Hello everyone I am new to the page and I am in need of some Excel help. What I am trying to do is pull the second word out of a string of text if the first word matches. Here are the examples of the string of text I am working with. eLearning AT3050 9:58am EST (New York...... OBSERVATION...

Hello - I have 2 cells: A1 is the time(text format) FROM 02:00:01 to 26:00:00. B1 should show "LF" IF A1 is between 24:00:01 & 26:00:00, or show "PT" if A1 is between 1 9:00:01 & 24:00:00,or show "EF" if A1 is between 16:00:01 & 19:00:00, or show "DT" if A1 is between 2:00:01 & 16:00:00...

Hello: I have done this so many time in the past but it's been more than a decade since I've "programmed" Excel so I'm a LOT (lol) rusty. I have a template setup for creating new customer accounting sheets. I'd like to alter this to use a MASTER sheet (currently called STATEMENT - name is also...

Hi all, I'm creating a property investment calculator and I'm trying to automate the stamp duty calculation with a formula rather than checking the government site for each and every property analysed. Eg, Cell B2 contains the purchase price, Cell J2 needs to show the TAS Stamp Duty payable on...

Hi All, I am very new to excel so bear with me please...! So, I have a set of numbers in two columns <tbody> A B C 1 a 13/3 14/9 2 b 15/6 16/3 3 c 10/3 12/3 4 d 14/6 14/9 5 e 8/10 6/5 6 f 10/11 12/3 7 g 12/0 8/2 8 h 12/9 14/0 9 i 9/7 10/7 </tbody> In column D I want to...

:confused:So I am working on this report where I have to calculate the taxes based on the Gross Profit. I had 4 different Gross profit for 4 different Quarters. I was able to do 3 of them but not the 4th. The reason being that is because it wanted the specific thing: Taxes are 20 % of the...

Hey guys, I am having loads of trouble editing my spreadsheet and it seems to be taking a really long time (over 20,000 entries)... I have some data for over 500 companies (1990-2015) and they all have different currency units which i need to convert (into EUR). It looks something like this...

I have a table which has different test scenarios and Results Column which says PASS,FAIL or PENDING. I have a Master sheet in the same workbook which has consolidated results from all other sheets. How can i write a formula for each sheet in such a way that if all tests has result "PASS" then...

I have an excel sheet that has numbers 1 - 20 in row 2 and various dollar amounts above them. I need a formula that if the number I put in cell D5 equals any of the numbers in row 2 it will return the dollar amount specified above it.

I work in medical insurance And I tried to use this formula to count the number of visits of a client =IFERROR(IF(AND(B2=B1,E2=E1,F2-F1<1)," ","Uniq Visit"),"Uniq Visit") But in some cases the formula counts the same date as two visits instead of one Please advice!

Dear sir, Here i want to maintain the attendance from time keeping software, My office time is 10:00 AM to 6:30 PM, and we have 15 min of grace limit, but if somebody comes after 10:15 AM then I need to remark as a half day, Please suggest me which formula will be use.

I have a separate that contains every week for the current year. I am running reports and graph from the data entered into those weeks. I noticed a patterned for the formulas I was entering and wanted to make my task simpler seeing how I have 20+ sheets to do the exact same thing. Basically I...