if and or statements

Hi! I'm trying to clean a dataset and only retain families with at least parent at home. I started going through it manually but it took 7-8 hours to do 3,000 entries and I have 30,000 entries left to do! There must be an easier way so I figured I'd add the criteria here and maybe someone...

I did find a thread that came close to my solution... but not quite :-\ I have two columns K and L. If L is blank use the value of K. That worked out just fine with: =IF(L40="", K40,L40) My question is how to add an additional condition of: IF K40 is also blank THEN type "Unassigned". It...

Hi I'm trying to create a formula to deliver three different outputs based on conditions of three columns. Conditions: IF a2 = 11 AND d2 = 028 return NI Landline OR IF a2 = 11 AND c2 = 07 return Mobile OR IF a2 <>11 return Other Number It;s necessary to check Col C...

I am in the process of creating formulas that I need to then join them all together as one larger formula. I need to check cells to see if they meet some criteria and if so then do a Vlookup. I have successfully done some of the formula but I ALWAYS seem to get hung up on the if, and , or syntax...

Hello all and thanks in advance for the help. Hopefully some of you more seasoned excel users can give some suggestions for this one: <tbody> DATE AMT 2/25/16 $50 3/4/16 $100 3/7/16 $300 3/16/16 $500 3/21/16 $300 3/21/16 $300 3/23/16 $300 </tbody> I need to...

Hi all, Having a bit of difficulty here figuring out where I am going wrong with this one. The table below is for a lighting audit. The inputs are in red and the formula in cells J2:AG4 are for monday only. The data set continues AH and onward for each day of the week. I want to be able to...

I want to perform a simple multiplication. I have two columns with default values (G9 and H9), and two columns that the user can put personalized information (E9 and F9). I want the calculation in column I9 to default to G9*H9, however there are three other scenarios that are preferred than the...