## IF statement Related Problems & Solutions

82 tags
Refine Tags

Results 1 - 30 of 82
[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...

123