# if functions

1. ### If function

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...
2. ### Combining UDF with IF function

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)...
3. ### Conditional format a cell based on the entry in another cell and also a dropdown...

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...
4. ### Vacation Accrual Formula Help!

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...
5. ### Macro works on first go around, then doesnt work correctly until excel is closed and openned again....only to work once.

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>...
6. ### Excel Query with IF, Vlookup and Data Validation

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...
7. ### Count frequency with multiple conditions

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...
8. ### Need help with auto calculating excess hours worked to apply to "Make-up" column before balance to "Over Time"

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...
9. ### NESTED IF FUNCTION HELP! TEACHER needs it to help students please!!!

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...
10. ### Elapsed Time in hours and minutes multiply by different rates

<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...
11. ### Nested if function using both "and" and "or"

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...
12. ### How to "Remove Duplicates If . . ."?

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...
13. ### IF Function with greater than and less than

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...
14. ### Looping array to highlight / colour sequential zeros

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...
15. ### Help IF condition with ranges

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...
16. ### VBA help with IF function

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 =...
17. ### IF Function with Variable Dates

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...
18. ### IF functions and drop down boxes

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...
19. ### VBA If Functions and Copying Rows over to new sheets

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...
20. ### VBA If Functions and Copying Rows over to new sheets

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back