if then

  1. S

    If formula to calculate worked hours

    Hello! I am trying to calculate my worked hours whilst accounting for my lunch break. I have a 30 minute lunch break if I work more than 8 hours, but do not have a lunch break if I work 6 hours. I want to incorporate this into my formula, so that it will calculate the hours worked and minus the...
  2. C

    Coding for if then statement not working right

    ABCDEFGHIJ682014 C&LWIGHTMAN JOSEPH S JR/ CHERYL ANN 4/30/201401200705$441.73$450.75$495.83$6,250692014 SCHOOLWIGHTMAN JOSEPH S JR/CHERYL ANN12/17/20141200708$101.51$103.58$113.94$6,25070Payment 17/31/201434.52FACE71Payment 210/22/201437.98FACE72Payment 312/17/201437.98FACE73TotalPaid In...
  3. J

    VBA - If Then Function

    Hi All, I recorded a macro but it is very ineffecient as I copied the code, dragged to fill etc but, I would like to perform the following but in VBA code =IF(I2=I1,N1&", "&E2,E2) Where it loops until the end where the approver stops (the sheets can vary in how many row it can be). The idea...
  4. M

    Set Character limit based on another cell contents

    Hi. I sure hope this is an easy one, but I can't seem to find the answer anywhere. I have a template that lists addresses and need to make sure that when the country is United States, the Zip Code has 5 digits since state zips with leading zeros are always being dropped. Is there any way to do...
  5. A

    Looping a MkDir function

    Hello all, I am trying to create a batch of folders where the code is normally quite simple: MkDir[D3&E3] I have several hundred that I regularly make. So far, I just have the same line repeated, but I'm trying to do some sort of loop or check to look for values in a column, and if present...
  6. R

    VBA Help: Pull from Sheet1 to Sheet2 under Conditions

    This should be simple....I just can't seem to get it to run right. Goal: Pull in column A from Sheet1 to Sheet 2 (starting at Row 2) where Sheet1 Column BR (70)> 0 AND Column N (14) = Var1/2/3. Issue: Currently it does pull in the correct rows, but it pulls them in at the same row number from...
  7. M

    If then statement not working

    Hello, My current macro works but I really need it to be an IF THEN statement. It currently looks at Sheet "RTW Report" range U2 to last row minus 2 and copies any cells with values into another sheet called "Charges" into C18. It then does the same thing for Column V on the "RTW Report" sheet...
  8. A

    Matrix Inverse message box help

    Hello all, I'm new to this forum, but I feel like this is a great place to get help. I am trying to find the correct If Then coding to use that will pop up a message box if there is no inverse to a matrix, but everything I have tried has failed. The closest I have gotten to something that works...
  9. B

    Naming Format Formula

    Hi All, I am trying to perfect a formula so that I can take the first name middle initial (when present) and last name and format a certain way. John T. Doe or John Doe So far I have this formula that works when there is a middle initial present, but will leave the "Space" and "." in when...
  10. T

    VBA For loop suddenly broken--what happened?

    This sub used to work perfectly. Then I added the variable misCell in the sub declaration and in the first line of code, and for some reason, the ElseIf statement in the first For loop is now broken. Nothing in that code changed (as far as I know). But suddenly it is filling all the "TOEZ...
  11. K

    Hide Tabs Based on the Choice of Multiple Items from Drop Down List

    Hello, I have a question regarding how to hide multiple sheets based on a user's selection from a drop down list. My spreadsheet has around 60 tabs (the sample only shows 30) and only 15-30 of these will be in use for a project. I would like the user to be able to use the drop down list to...
  12. A

    If then formula help with multiple rules - need help!

    Hi, I would like to create a drawing tracker sheet which shows if items have been issued or are overdue / days remaining. Thanks in advance! The way I need it to work is... For column E to calculate an overdue date or days remaining with positive / negative numbers in relation to todays date...
  13. C

    Input a value in a cell IF another cell contains a value

    I think this is a tricky one. I have a sheet where I paste different amounts of rows every time I use the sheet. I want the cells below C2 to show "TEXT" only if the cells below B2 contains value as I show on the image. If I paste 6 rows below B2, I want 6 rows below C2 to show "TEXT" in every...
  14. A

    Help with another IF THEN

    How do I write a formula for: IF B<400, THEN (H*L)*150, IF B>400, THEN (H*L)*160. What is this type of formula called?
  15. B

    Suggestions on if one cell value equals another cell value to insert a text in a new cell

    I might talk in circles here but I will try to explain the best I cant.... I have a condition format in column AJ for duplicates to make text red.... What I want to do now is in the next column I want to mark a Y or N for reviewing purposes. I feel like the answer can be so simple but I dont...
  16. P

    If/Then Conditional Formatting

    I know I am overthinking this. It is not a difficult task. For the life of me, I cannot figure out a simply Conditional Formatting. I have 2 pieces of criteria: If the value in cell D23 is equal to or less than 0 then highlight D9. If the value in cell D23 is greater than 0 then highlight D24...
  17. L

    Help with if then query

    i All, In English, I want to populate the cell J4 based on the table value (see attached image) If cell IA = WDDS the populate with table WDDS value 6:00 If cell IA = WDAS the populate with table WDAS value 12:00 If cell IA = WDNS the populate with table WDNS value 20:00 If cell IA = WEDS the...
  18. S

    If X in C4, copy to E4, Dependent Validation

    I've set up Dependent Data Validation so when a specific Session is selected only specific options are available in the next two columns. However, the third column the user is to input a number. The only restriction is for the Session called Previous Group. Those two dependent validation columns...
  19. J

    Nested IF in Sliding Scale Formula

    Sorry. I know there is a simple solution to this and I’m just blind to it. Calculating Sliding Scale Percentage Current Formula in cell A46 =IF($B$33<5000,”.007”,IF($B$33<10000,”.006”,IF($B$33>9999,”.005”,””)))*10 This works perfect, however I need this formula to consider the value of A43...
  20. K

    If Cell Contains Hyperlink Count

    Hello I am trying to construct a vba macro to count everytime a cell contains a hyperlink in range of data. Currenly having it search the row for a hyperlink and then if it finds a hyperlink it will count and not delete the row, deleting the row if it doesn't contain a row. I am currently having...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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