condition if

Hello all, I have some table build up from different formulas and so on. Final result is some huge sheet filled with columns and lots of rows showing just True or False. I'd like to know how i could hide all columns that are all their values True, so i can just end up with just the False...

Hi, I have this dynamic range which depends on dynamic data and below condition: If the value in cell AC10 is not equal to any of the values in Range: AK3:AK9 then change the formula should be...

Hello, I’m newbie and I need put in validation data a formula for check the next: • In column "H". If the column "G" is greater than 0, it must be greater than 0. Otherwise, it must be 0. Help me please Thank you n Regards.

Hi, I have 4 ratings : Highly Engaged, Moderately Engaged, Barely Engaged, and Disengaged. What I need is to write a macro that change the text colors in a text box with conditions, and below macro works perfectly fine, however, I need to add another condition, which is "if BE (Barely Engaged)...

Hello: Is there any way I can automate the "RANGE" column to use a formula that would return the A/B/C value if it's within that range I'm giving to the right?? I've tried if /or statements but I'm not successful Loc VALUE %of sales % cumm RANGE 1 $152,503.00 8.37% 8.37% A 60% A...

Hi Team, Can anyone help me with below requirement....here is the data <tbody> Customer Product Name Amount Contribution by Final Status Cust1 Product 1 17,991 Team 1 Cust2 Product 2 19,901 Team 2 Cust3 Product 3 18,948 Team 3 Cust3 Product 3 10,730 Team 1 Cust5 Product 5...

Hello - and thanks for the help! Here is what I have: =IF(OR(AND(C6>C5,O5="L"), AND(C6>C5,O5="S")), E6-C5, "www") This formula DOES return a value for the first condition, but will not return anything other than what appears (to me) to be the first condition, for what *should* be a...

Hello all. I'm trying to get some straight-through-processing set up for a bunch of EOD reports my team sends to various banks. As it stands, I have some great code that will automatically save a file based off the bank the data pertains to as well as the date of the information. I also have...

I have a dropdown list in column 1. I made conditional dropdown list in column 2. I need to have dropdown list in column 3 based on names of columns 1 and 2. Column 1 is direction. Column 2 is vehicle and column 3 must be crew for this vehicle. Column 3 depends not only from vehicle but from...

Hello, I have a list of hundreds of numbers on column A. I would like to have a formula on column B that if the number starts with the digits "29", then the worlds in column B would be "sales agents", if it does not starts with "29" then to show "customer care agents". Thanks for your help!!

I need help... Using =VLOOKUP(B2,Sheet1!A1:I95,4) which results in a "1" in the cell I want to add a condition that if cell is "1" then "Yes" if not then "No" I tried just a normal =VLOOKUP(B2,Sheet1!A1:I95,4)+IF(1,"Yes","NO") and I get an error. Any help?

Hi all this is my first time coding from scratch and I have hit a roadblock I am trying to create the following 3 condition but I am at best only able to get two to work. Could any one advice on where went wrong? 'To create the following condition 'If less than 7 days interest = 0% 'if 8 to 30...

hi all, i would appriciate some help :) i have two sheets named Unos_treninga and Test. I need to copy range I16:AA40 from Unos_treninga sheet to sheet Test to first empty row. There is condition - copy cells if cell in column I is not empty. data is entered in every row in range, there is no...