**[Solved] How to do an IF statement with multiple dates and criteria** *Summary*: So I am trying to create and IF statement that takes into account the submit date and the requested date for PTO wherein if the Requested Date is less...

**How to create an if statement for a validation list?** *Summary*: I have a spreadsheet that tracks students. On sheet 1 is the complete of students. On sheet 2 is a report. I need a formula for a dropdown that will l...

**[Solved] If statement not working for no apparent reason** *Summary*: When I enter: for /f "tokens=2 delims==" %A in ('wmic os get OSArchitecture /format:value') do set architecture=%A in CMD, it returns: archite...

**Writing C++ Programs using the switch or if statements** *Summary*: I have this two assignment from my Lecturer Hope some one can help me solve them. 1. Write a program to show if a particular year is a leap or not 2. ...

**[Solved] Nested IF in batch.. confusing?????** *Summary*: alright, i am writing a program to do many different things, and i need the nested if statement to work, but i have tried it many different ways and i...

**[Solved] Why does my input cause a batch file crash?** *Summary*: Hello, I have the following type of code that works most of the time... :LABEL1 set /p input=Do you like apples (Y/N)? if %input%==Y goto YAY...

**[Solved] Trying to combine an IF statement with NETWORKDAYS** *Summary*: this is the formula i have and it calculates the total days between F4 and T4 but i want to calculate the network days any ideas =IF(T4=0,TODAY()-F4,T...

**[Solved] Help with an IF statement using dates** *Summary*: My basic IF statement is IF J6>110% and IF L6<-5000, return "REVISION NEEDED" otherwise "OK". I've got this part using this: =IF(AND(J6>110...

**[Solved] EXCEL If Statement Using Dates** *Summary*: I want to have two dates within the if statement. This is what I made, but i need it corrected. =IF(J2>DATEVALUE("5/31/2014"),"GOOD","EXPIRED" J2>DAT...

**[Solved] how to use IF statements when using Vlookup** *Summary*: I'm trying to figure out how to use the VLOOKUP and IF statement so when their is value to say "Yes" or "No" when there is no value. ...

**[Solved] If statement using data validation in Excel 2010** *Summary*: I am trying to use the data validation function to allow certain range of numbers based on a particular category. Category Range Allowed Superior >3.5...

**[Solved] If statement with AND plus the OR function** *Summary*: How would this formula work in an Nested IF Function for Excel 2010? Column G--Salespeople who have worked for XYZ Security Systems more than seven ye...

**[Solved] excel 2007 how to return 1 or 0 with IF** *Summary*: How do you give a "Yes" or "No" value as a 1 (0ne) for "Yes" or a 0 (Zero) for "No" in Excel 2007 to do an if statement. =IF(P3=1,N3,0) ...

**[Solved] need help with batch variables** *Summary*: I'm trying to use an if statement like so...if c%value% == 1 goto new bookmark I have multiple variables labled c1-c100. Most of which are bla...

**Value or formula in same cell?** *Summary*: I have created a nested if statement that either references a lookup table or requests users to input data ( into cell E25 ). The the nested if state...

**[Solved] Excel Problem If statement** *Summary*: How can i put the same dates upto 73 row and after that a blank second date will come ? I have 60000 rows in one sheet, and I have to put the same dat...

**[Solved] if statement using dates** *Summary*: help! I have a range of data that i need to analyze. if a date is 3/1/2014, then i need it to return +15 days later in the next column and i have many...

**[Solved] I am trying to do a if statment in excel that has a date** *Summary*: I am trying to do a if statement in excel that has a date, it should flag up red if the date is greater then 3 years ...

**[Solved] for 2010 nested if** *Summary*: need an example of a nested if statement where if a1 is greater than 1 but below 10 we show 1 but if a1 is greater than 10 but less than 20 end ...

**[Solved] CMD outputs syntax error on if statement** *Summary*: I am working on an internet browser for a computer inside a game I'm making. Here's the problem: CMD outputs an syntax error message when reading the ...

**II am trying to use an if statement** *Summary*: I am trying to calculate a column to read if column E3 is greater than 0 I want to times this value in column E4 by .03 percent to come up with a tot...

**[Solved] using the if statement in excel** *Summary*: need if statement that says if n2 is 9000.00 or less, take N2 times 2.70%, if it is greater than 9000.00, then zero. =if(n2<=9000.00,*2.70%...

**[Solved] Color of cell or font color in cell change** *Summary*: I would like to know what if statement to make so that the results are as follows: IF a1<a2 then either the color of cell a1 would change color of ...

**[Solved] if statement to determine what falls between two dates and d** *Summary*: i'm needing to access two cells with dates in each and determine another cell to see if it is within those two dates and if so, display another specif...

**[Solved] IF statement and VLOOKUP HELP!!** *Summary*: I have 2 sets of data which I need to update on a regular basis. one set of data comes with out relationship managers (RM) names and the other has the...

**[Solved] If Statement with a third condition** *Summary*: I have a cell with an IF statement that functions as follows: =IF(((((J9-H9)/30)+((G12/1920)*12))/J6)>=100%,"ACCEPTED (1)","REJECTED (1)") I hav...

**I am trying to do an if statement to include a data validati** *Summary*: I want to have a formula that shows will display a data validation list only if certain text is displayed in another cell and to show as N/A if it is ...

**if then statement for range of text** *Summary*: I have a range of cells in Excel that contain the text LOW, MEDIUM, HIGH. I would like to create a formula that scans the range to pick out the highes...

**[Solved] If statement not working** *Summary*: =IF(AND(C14="not grossed up",G6="CA",L10*-0.01,0)) Why will this if statement not work? I'm trying to calculate only if the two condisitons are meet 1...

**[Solved] DEBUGGING: Nested drop down in an IF stmt using data validat** *Summary*: Hello! I'm trying to get the following formula to function.. and as it's setup the final [false] parameter keeps showing up, as IF it's ignoring the r...