if conditions

Hi, I was trying to use IF, AND, OR formula to build the condition below but I'm not sure why it's not working. The condition should be: if Category is high or Critical and Status is Express then it's TRUE, otherwise False. The results column is the desired results. Category Status Results...

Morning,I am trying to create a formula for a spreadsheet that is linked to another spreadsheet.In my spreadsheet i would like the formula to look at one cell say for a particular text, and if the information is correct then look to another cell for a particular number, which if both are correct...

Hi Guy's I am very new to VBA and i am struggling with a code based on the option which are selected from the drop-down list. Drop down list is in column D in the sheet "MyData". Columns A-C will be populated with data. What I want to do is: if option "Terminate" or "End" are chosen from the...

Hello everyone i need a small piece of code. for example in column c i have alpha numeric characters like "PLN5555" so i need a code that prompts me error message when i type alpha numeric characters less than or greater than 7characters. any one can help me out in this. thanks in advace

Hello fellas, I have over 60000 rows of data in excel 2010. Each row have unique client name like I have 4 client names I want to keep the same as their real name in Client placeholder to automate column. I have another 40 clients like John and David that I want to assign them Other in Client...

cheque book Bank Data Date cheque no amount matching cheque in bank date cheque no amount 01/10/2009 692201 40000 no match 01/10/2009 692203 23000 02/10/2009 692202 50000 no match 05/10/2009 692201 40000 03/10/2009 692203 23000 no match 06/10/2009 692205 51000 04/10/2009 692204 29000 no...

Hello all, I am wokrking a 100k line spreadsheet and need some help. I am trying to display the value in column D from sheet 1 of my file to sheet 2. The catch is I need columns A, B and C to meet certain critera. Col. A Col. B Col. C Col.D Blue Circle Table 1000 Green Square Chair 2000...

Hi Experts, I have query regarding If condition macro. Will you please prepare and get me the macro code Here is an example 1. Find and Copy Condition 1 If 20310-0000 is available Copy all data related to 20310-0000 and paste into Sheet2 Else Msg box No data Condition 2 If 20320-0000 is...

Is it possible to create a macro that follows the following conditions?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> If any cell within the range a6:h200 is selected then that cell will have the word “no” entered into it. This should happen...