if functions

I would like to know what is the full IF function with regards to the above screen shot. If all cells B1:B5 are noted as "Joint" then the B6 result = "Joint" If all cells B1:B5 are noted as "Sole" then the B6 result = "Sole" However if any one of B1, B2, B3, B4, B5 is Joint or Sole (therefore...

I need to combine a UDF (below) with a set of IF functions. Function MaxN(n&, r As Range) Dim i&, j&, m#, t#, v v = r.Cells.Value2 For i = 1 To UBound(v) If UBound(v) - i + 1 >= n Then t = 0 For j = i To i + n - 1 t = t + v(j, 1)...

Hi Guys, Firstly I'm really sorry if this question has already been asked, i did have a really good rummage and couldn't find anything. i have a column that I enter a code in (lets say E4), which is the one i want to conditional format. I want this to be linked to a different cell that...

Hello! I have been assigned to making a vacation accrual spreadsheet that will auto calculate vacation time for the coming year based on hire date. The parameters are complicated and I am stuck on how to do this. 6 months after their hire date they start accruing vacation at a rate of 3.07...

So I am trying to create a button that opens a userform thatasks questions on what the user wants to do. It is kind of hard to explain so Iam going to try to insert screen shots of what I want to happen. Below is part of a table that is created on the main pageentitled “Status Sheet.” <tbody>...

Dear Experts, I found myself in a situation of help - I have a file which is attached at following URL https://drive.google.com/open?id=0Bxtc6jUuxe_pY0hoQXBsaWNhOTg So If C24 is Yes then E25 needs a value (from drop down – otherwise it needs an error message to detail the spec). Equally if...

I would like to count how many unique values (= the frequency) in column A with the following conditions: * I only want to include values corresponding to an "X" in Column B * I only want to count the number of values in Column A which are constantly "Blank" in Column C. Meaning if I have a...

I am trying to get the Timesheet to automatically allot hours worked in excess of 8:00 per day to “Make-up” column to a MAX of 40:00; remaining balance if any should be allocated to OT Hrs. Please save me from myself and too many )s! :rofl: <tbody> A B C D E F G H I J K L M N O 1 Company...

I am not an expert but I can get around excel through trial and error and tutorials. Trying to create an if function to assess student data. I have a ruberic for student scores that I am trying to turn into an IF nested function or some other way to be able to take the score in one cell and turn...

<tbody> A B C D E 1 <tbody> COMPUTER NAME </tbody> <tbody> TIME STARTED </tbody> <tbody> TIME FINISHED </tbody> Duration Amount 2 A <tbody> 07:45:00 AM </tbody> <tbody> 10:00:00 AM </tbody> 3 B 4 C </tbody> I need to display in column D the...

Hi there, I have four 1 year long periods were a "special offer" was available and im trying to build an if function in B2 that identifies whether the offer was available on a random date (B1). <tbody> A B 1 Random date Dec 04 2 Offer available 3 4 nov 03 nov 04 5 apr 06 apr 07...

Hi all, I have a long list of grant data (~450 entries), and every row represents one grants. There are two main kinds: GOS & project, and each entry is coded with the organization name (Column: Organization Name), and one of those two codes (Column: Grant Type). I want to remove...

Hi, I'm trying to get this IF function to work, it's not giving out an error message but using the wrong figure to do the calculation. Checked all the reference cells and can't work out what is going on with it! =IF(H3=1, G3*T3, IF(H3=2, U4*U3, IF(H3=3, V4*V3, IF(H3=4, W4*W3, IF(H3=5, X4*X3...

Hello, I have 4 columns with data H, I, J and K. I need to write a macro that will search through H, starting at H14 and look for a single 0 (zero) in all cells with data in column H starting from H14. This is where I get a bit stuck as I don't know how to add IF functions through arrays. So...

To make my question easy let's say I have two columns A and B. So my issue is that I would like to easily format my B column with text. In my A column I have inventory numbers. Additionally some of the data I pull over already has pre-filled text in column B. I don't want that text to be...

I really struggle with IF in VBA and have no idea where to go with this as there are two criteria to match. I have a simple enough work book with two sheets - in sheet1 the user inputs a day in A1 (from drop down) and an indicator (either 1 or 2) in B1 What I am trying to do is IF A1 =...

Hi, I am trying to use the IF formula with some variable dates and have tried a few combinations but have been unable to get it to work correctly for all the cells yet. Basically I have two columns titled 'Due Date' and 'Cleared Date' and a third blank column. In the third column I want to...

Good morning Mr Excel, I am trying to create a formula that allows me to have different options populate a cell depending on the content of another cell. I think i have done this before but cant remember the finer points, =IF($C$7="Select Axle...

Hi, I'm having trouble coming up with a way to create a code in VBA that would parse through a table of data, recognize if a value was in between a set of numbers and if it was, copy and paste the row into the next avaiable empty row in the new sheet. Then, if all went well, it would go down to...

Hi, I'm having trouble coming up with a way to create a code in VBA that would parse through a table of data, recognize if a value was in between a set of numbers and if it was, copy and paste the row into the next avaiable empty row in the new sheet. Then, if all went well, it would go down to...