statements

Please help. I have this =IF(CA18<BY18,"YES","NO") I want to add if COL CA:CA is blank then leave cell blank or go onto <by18,"yes","no") i="" want="" to="" add="" if="" ca="" is="" blank="" then="" leave="" cell="" or="" go="" onto="" if(ca18<by18,"yes","no").="" can="" do="" this?<=""...

Trying to find if this is possible. I have a list of names which I am trying to do If Statements on. I need the if statement to return a value if a specific cell equals one of the names on the list. The list contains 75 people so would need multiple if statements. Instead of doing an if...

Hi I have this data set that i need to transpose but i dont know exactly where to start to explain what im trying to do so i will try my best to explain I have a data set that looks like this Book1ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI1Respondent IDCollector IDStart DateEnd DateIP...

I am trying to have a multiple criteria if statement to vlookup a value based region (which each is on a different tab). Each of the if statements work fine on their own, but not combined. What am i doing wrong here...

Hi, I'm trying to check two cell values where both must be within the same range like this... If 1<=Cell a<=6 and 1<=Cell b<=6 then execute This is what I have at the moment... If ws2.Cells(d, "B").Value <= 6 And => 1 And ws2.Cells(d, "C").Value <= 7 And => 1 Then Thanks

Hi, I need to merge the following two statements and I'm not sure how to merge them for them to work? =IF(E288="","Incomplete",IF(OR(E288<D288,E288=D288),"Completed",IF(E288>D288,"Cmp Late"))) =IF(C288>E288,"Early","Cmp or late") any if statement genius?

Hi, I currently have a query about a formula that i have designed. <d$27,vlookup($c$18,$b$13:$d$15,2,false),0) <d$27,vlookup($c$18,$b$13:$d$15,2,false),0) <d$27,vlookup($c$18,$b$13:$d$15,2,false),0) =IF(D18<D27,VLOOKUP(C18,B13:D15,2,FALSE),0) I need to add a discount percentage, that is...

Scenario: I download a monthly statement each month The statement has transaction dates. I give each line of the statement a category. I want to analyse the statement by month using a PivotTable. Each month when I download a new statement, I want to add this into my PivotTable that consolidates...

Hi all, I am working through a spreadsheet converting multiple VLOOKUP statements to IndexMatch equivalients but have found one I can not work out. This VLOOKUP statement has a nested VLOOKUP statement that returns the value which needs to be looked up...

I need help putting in ranges for my embedded IF's in a formula If $A7 is = to 1-7 (meaning 1,2,3,4,5,6,7) return value 0, if $A7 is = 8-22 return value of 1, IF $A7 is 23-37 return value of 2, if $A7 is 38-52 return value of 3 Thank you

Hi everyone, I'm looking to export my bank transaction statement into excel and want to create a list of snippets with categories so I can auto categorise some ofm y statements. I thought maybe a vlookup as an array, but this didn't work...

I know there is any easier way of doing this by combing if(and(or statements, but I did it the long way. How can I combine all of these IF Statements to 1 formula? IF((AND($A41=1,$B41=0,$C41=0,$D41=0,$F41=0,$G41=0,$H41=0,$I41=0,$J41=0)),"Step 1","")...

Currently I have been using this function plenty of times; however, when adding the additional if statements to the OFFSET it is causing errors. I have tried it multiple ways and simply want to drag down to retrieve the information for customers. The error it gives me now that I have a bunch...

Hi there - I'm newer to using excel, (I know, I know), and I've hit a roadblock with understanding IF/OR statements. I've seen examples for what I'm trying to do, but no matter how many times I try to duplicate the statement, I can't make it work... The old statement a spreadsheet I'm working...

The formula I am using is: =IF(AND(C13>0,C25<C30),"MIN-OUT"),IF(AND(C18>0,C27<0),"MIN-OUT",IF(C27<=0,"MET","OUT")) My formula is in cell C29 and I am getting the #VALUE ERROR. I've checked all the cell formatting and they are all set to number. Any suggestions? Here is the data. Can't...

I've tried each of these IF statements in all the orders that seem logical but I think there is something wrong with the IF statement highlighted below. Essentially what I am telling my ELSEIF to do: If TRUE already exists in the cell, then leave it be, keep it true and move on. Instead it...

Dear All, In my Col A, I have fixed words, which I want to make them in small letters only. words are, Col A contains statements, any statements wherein, the above words are there...and they should remain in small letter... Pls share the code...

Good afternoon, Can anyone please tell me why the following formula will not put a line break at the end of the first two statements please (like ALT-ENTER when in a single cell)? =CONCATENATE("Title ", TEXT(INDEX($B$18:$B$2517,MATCH(E$10,E$18:E$2517,0)),"#,###,##0"),CHAR(10)...

Hi all. I have an .xlam file that is password protected for viewing. At times the .xlam accepts user inputs and saves itself to archive the inputs. (This is accomplished with simple thisworkbook.save statements in applicable code, as well as a redundant worksheet_save private function for the...

Hi all. I have an .xlam file that is password protected for viewing. At times the .xlam accepts user inputs and saves itself to archive the inputs. (This is accomplished with simple thisworkbook.save statements in applicable code, as well as a redundant worksheet_save private function for the...