if then

Hi all wonderful Legends! I need some help with a form I'm trying to create. The basics are below. If the time is between 06:00 and 14:00 a box on the end needs to read DAY, or if between 14:00 and 22:00 ARVO, and 22:00 to 06:00 NIGHT. Then, if the Completed column shows no, i want another box...

I used to use if then else in Crystal Reporting but haven't figured it out in Excel. I have a column with rows of cells with different percentages in them, let's just say Column Q rows Q2 through Q30. In Column T, T2 through T30 I would like to put a number based on whats in Q. Tte numbers in Q...

Hey Team, I am looking to do some conditional formatting on a Gantt chart for Prerequisites. I am using the styles "Good Bad and Neutral" from the styles tab. Columns D E F G are manually assigned a number. I want the formatting to look at the number assigned to the cell, find the row...

I would greatly appreciate it if someone could help me. I am feeling not so smart today. LOL I need to create a formula based on several criteria. The first step is to find all of the matches in one column, then I need to take all of the items that match and tell it to look at another column...

Currently I am trying to have variable decimal formats displayed across a range of cells. The amount of decimals will depend on how large the numbers are. The numbers range from 100,000.00 to .000000001. I can get this formula to work properly and it displays the decimals as I have...

Hey Everyone, Sorry for the silly question but can someone help me with the VBA version of this formula: =IF($E13=TRUE,$B13,"") Basically I don't want to put the formula directly in the cell where it can be overwritten, I also need it to apply to all rows (columns are fixed). All this does...

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

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

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

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

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

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

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

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

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

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

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

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

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

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?