## If Related Problems & Solutions

31 tags
Refine Tags
Search Tags:

Results 1 - 30 of 31
[Solved] Using IF AND with Vlookup
Summary: Hi there, i am trying to find a way to come up with a formula to organise a sheet i am working on. Basically I need to do a few factors 1. If O=TRUE ...

[Solved] Syntax error on IF statement for no reason (Batch)
Summary: I have this game patcher in batch that I am working on, I decided to add progress bars (Echo [ÛÛ ]). Once done, the IF statements started returning...

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] What am I doing wrong with my batch IF/THEN?
Summary: Hello, I'm making a coding language for one of my buddies as a joke. It'll probably never get finished though, because I suck at batch :( Can somebody...

How to use an If statement with binary file---BATCH
Summary: I'm making a text based game with BATCH and I'd like to know if it is possible to do something like this: @echo off if yoyo.bin=WARRIOR CLASS ( if o...

Trying to return value from another sheet with ranges
Summary: Could someone please help me! I am trying to figure out what I'm doing wrong. I want to have the user enter a loan amount and a percentage, then in m...

IF(and formula with 3 conditions
Summary: =if(h4772>=.10, h4771>=.10,1,if(and(h4772>=.5,if(and(h4771>=.5, h4770>.5,1)))),0) The condition places "1" in the cell if(h4772>=.10, h4771>=.10,1 But...

[Solved] if %var% == 1 goto blah isn't working?
Summary: I have a batch file, and was making an if statement. Then I went in and tested it. It closed, so I got an error log that said 'goto was unexpected at ...

Multiple If Statements with multiple Cmd's
Summary: I am having trouble getting a full understanding of how to use multiple if statements. I want to first use the msgbox, and if vb yes then import the t...

How do I compare 2 dates with if concept
Summary: We are trying to figure out when to escalate a late entry to our database. Example A1 B1 Evidence Date Due Evidence Accep...

Dependent data validation drop down list
Summary: Is it possible to create a data validation drop down list embedded in an IF() statement in MS Excel? What I want to do is this: create an if statement...

Excel Macro If a cell is blank, how to paste?
Summary: Hi, I have a list of prices. I want a macro that when a button is pushed, the data will go from one cell to another. However, I have 10 rows at the to...

Findstr | if () else() --what's wrong?
Summary: I have this as the last part of a script and I consistently get an errorlevel of 0 even if %mydate% doesn't appear in the file that I'm searching. I'...

VLOOKUP + IF formula???
Summary: Hi all, I'm fairly inexperienced with advanced excel functions, so this might be a ridiculously simple problem to solve. But I have 2 worksheets and I...

Unable to implement IF conditional statements
Summary: I'm able to run it and establish it but the thing is conditional statements does not get evaluated and it executes everything. so please if anyone can...

If Statements and Vlookup - compare to sheets
Summary: I have a workbook with two sheets Sheet 1 called Raw Data from IW and Sheet 2 called Raw Data to ICI Sheet 1 containts a column of numbers like 2548-1...

Batch check for valid HTML color #*-asterisk
Summary: I have a windows batch program that asks for a valid HTML color in HEX-notation. (ex. #000000) Here's the issue: I need the batch program to check tha...

IF excel 2003
Summary: I've got 50 rows of product descriptions in Column A. Quantity of product in Column B. I want to create a list on a different workbook within the same...

Formula chaos (IF, OR, AND)
Summary: Hello, people. You helped me perfectly last time, and I'm just in a bit of a rut again, as I've been cluttering about with this formula for an hour. I...

Summary: Hi there - how do i link data in excel? My problem is that I want to assign attributes to names in a drop down list. So if i chose x in the drop down ...

[Solved] Excel If statement & Data Validation
Summary: I am trying to do an if statement to include a data validation list. So if cell A1 says "Plasma" then in cell B1 show a drop down list of the size of...

Excel IF statement for 9-5
Summary: I am trying to build a report which shows if a date and time is between 9-5 Column 5 has a date/time value of 04/01/2010 13:36:00, I need to output th...

Can I use double quotes in MS-DOS 6.22?
Summary: Can I use double quotes in MS-DOS 6.22? I created a batch-file, including DOS commands I point out: IF EXIST "myfile.txt" echo The file exists! IF "%m...

Nested if problem
Summary: Hi, I have written two different types of nested if statement. One which has more arguments/conditions returns an empty cell which is what it should ...

Nested IF statement
Summary: Hello, I have to make a table with the holiday plans for all our employees. On one side you enter the days for the vacations, on the other side there ...

Goto inside if codeblock
Summary: Hello, I have a problem using the goto inside the if code block; error:The syntax of the command is incorrect. this is a part of a larger script I'm ...

IF statement. Dates with different outcomes
Summary: I am trying to extract some data on dates to a dashboard to present it in a pie chart. I have a list of dates relating to when something was tested. ...

Multiple IF in CMD
Summary: Hi all, I wanted to use a batch file that gave you a choice of 1-3 and and if anything other than 1-3 was entered, the batch file would say its incorr...

Nested IF Statements
Summary: Background: I have two validation lists with possible values in Excel. The first list has a number of values. I'm only interested in one value- X. The...

Vlookup, IF, Match, ISNA
Summary: Hi, I need assistance on how to create a MS Excel formula which matches criteria from two different MS Excel files. i.e. I have columns named Part N...

12