if then statement

Happy New Year and thank you in advance. I have 3 if statements which work individually but I don't do semi complex formula writing often enough to know how to do this properly. If A1 is blank then concatenate this way, concatenate that way If A1 is not blank and B1 is blank, then concatenate...

Hi, I am having trouble getting the correct formula to work for the below data set. My goal is to remove the two left characters from the cell and then calculate the number via a simple division formula. Basically, I'd like to be able to remove the MB or GB and then calculate it based on the...

I just started learning the ropes to VBA and don't fully understand it yet. I am trying to create something that will change the value of two different cells, based on the contents of one cell. Specifically, if the text in column B says "shoecare", then the contents in column E need to change...

Hello, I am trying to automate a footnote for a report. Here are the conditions: If cell O13 does not equal 1, I want cell B39 to display the following text (including asterisk): **O13 denials are included in the table below. Where the value of O13 is displayed. If cell O13=1, I want cell B39...

Can someone tell me what if then statement I would use in order to calculate the following: If W2=Y2 (or) if X2 = Y2, then return "yes - okay", if W2 doesn't equal Y2 or if X2 doesn't equal Y2, then return "no - review". Thanks so much for the help!

Can someone please help me with this formula. It is almost doing what I need it to do! I need it to take any number in K2 that is 65,66,67,68,69 & multiply the number in T2 by .65. If the number in K2 is >= to 70, I need it to multiply the number in T2 by .50. =T2*IF(K2=65,0.65,IF(K2=70,0.5,1))...

Hello, I posted a thread earlier on this particular project I'm working on. Most issues have been solved and the program is sort of working. It's not encountering errors that stop the macro like before. The macro runs but i think the issue now is with the If-Then-ElseIf-Then-Else statement (see...

Good evening, I am trying to clean up a macro that I recorded with the recorder. Its basic function of the macro is to filter all the data labeled to Phoenix (Column B), paste it on a new tab and then sort and subtotal by column G. I've gotten the majority of that accomplished, but I tried...

Trying to do a double if statement. In one column I have a number but I want to get a result if the number is less than -99999 or over 99999 and give me a result of a one. Right now I have have the column with (11mm) as a conditional format, but I want to put a value in another column that if...

Hi, how would I indicate if a date is on or after 7/16/2009 to indicate Tier 2 otherwise Tier 1? Thanks kindly!