multiple ifs

Hi can anyone help please, I am trying to create a formula that looks down a list of data and concatenates the names of two if conditions are met? So in the example of shop is A and region is North then concatenate names save and Mike. Thanks!

Hello all! I am having difficulty using multiple IF statements in 1 cell. There are 8 options the IF statement needs to check which are: if J9 = BB, insert "1" in cell B9 if J9 = OS, insert "2" in cell B9 if J9 = OST, insert "3" in cell B9 if J9 = VP, "4" if J9 = RR, "5" if J9 = A3, "6" if...

Hello all does anyone know how to add a multiple IF test in one line of a SWITCH statement? I am testing for amounts but sometimes need to check other parameters as well. My example is: Test:= SWITCH(TRUE(), values(Table[Amount])=0, "No Sale", values(Table[Amount])>=100, "Large sales"...

<tbody> Status MAL MQL SAL SQL First associated date Conditions True/False Raw 10/25/2016 10/10/2016 10/10/2016 Pursuing 1/12/2017 <tbody> 4/18/2017 </tbody> 4/18/2017 2/28/2018 </tbody> So these being my columns, I need a To fill the last column with conditions that satisfy 1)...

Hey everyone, This is a basic math inventory and order tracker. Each week 1 inventory is to be imputed, I want the code to repeat as necessary until the next inventory column is empty Also to highlight Negative numbers in RED and Text in ORANGE. anywhere in the big selection within L2 to...

I am trying to do some conditional formatting which I feel should be simple but I am getting nowhere :banghead: <TBODY> Product type</SPAN> Code</SPAN> Area</SPAN> X</SPAN> 1-A-3-008</SPAN> W-1 Back26</SPAN> Y</SPAN> 3-B-1-023</SPAN> W-1 Back23</SPAN> X</SPAN> 9-N-4-369</SPAN>...

Hi I am working a spreadsheet that is like a bank statement. Three columns "IN" "OUT" "Balance. I have figured out how to hide the balance if nothing is in one column, but if something is in one column and not the other it still hides it Any help would greatly be appreciated. I have...

Hello again! I m trying to solve it, but ... I have a table with 4 columns and 22 rows: <tbody> From To Statement1 Statement2 0 0.19 3-5 0 0.20 0.30 4 3 .... .... ... .... 4 5 1 6 </tbody> I would like an if (vlookup maybe) statement as below If D1 ( a cell outside this table...

I really struggle with IF in VBA and have no idea where to go with this as there are two criteria to match. I have a simple enough work book with two sheets - in sheet1 the user inputs a day in A1 (from drop down) and an indicator (either 1 or 2) in B1 What I am trying to do is IF A1 =...

I really need your help! The following formula works: =IF(F7="NR",R7-T7,IF(F7="OR",R7-T7,IF(F7="PR",R7-T7,IF(F7="SR",R7-T7,””)))) I need to add, though, that if there is nothing (no date) in cell R7, then this cell should be left blank. I have the following formula and it's not working...