if then

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?

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

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

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

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