conditional if

Hi Here's what my dataset looks like: A B C <tbody> Area1 Customer Test1 Area2 Customer Test2 Area3 Customer Area4 Customer Test4 </tbody> In column D, I would like to show Test 1 in D1, Test 2 in D2, Test 4...

Hi, I want a conditional formatting if statement that does the following: note - All cells to the right of it (B1, C1, E1 etc) should match column A if B1 is blank, don't change the color, BUT if B1 doesn't equal A1 (if a cell value is entered), then make the fill red color I then want this...

How to tally counts in an table as below across 2 columns, please. Simplified worksheet below. For each 'payor', I want to be able to count the number of each 'order type'. Something to the effect of: COUNTIF (payor="GR" AND order_type="P") There are only 2 payor values and 2 order type...

Hello,</SPAN> I am trying to create an IF statement for my “Notes” column but I can’t figure out how.</SPAN> I have 3 Yes/No Columns that show exceptions - LoanExcept, AddrExcept,GARExcept. I’d like to populate 1 Note field that indicates which columns have a “Yes” - see example below.</SPAN>...

I have three columns. The first is detecting and flagging if the price is coming from a Resistance Turning Point (1) or a Support Turning Point (2). A blank cell indicates that the price for the day did not occur at a turning point. The result of this exercise is designed to return/display a...

Hello Folks, I have following conditions that I want to check on a cell 1. IF Value >140 then it returns A 2. IF Value between 120-140 it returns B 3. IF Value is between 100-120 it returns C 4. IF Value is between 80-100 it returns D 5. IF Value is <80 it return E How can I do this in a...