condition formula

The formula I am using is not calculating correctly. What am I doing wrong? =IF(C5=0,"",IF(C5>0,SUM(C5-20),IF(A5="*Nov*",A5="*Dec*",A5="*Jan*",A5="*Feb*",SUM(C5-98)))) What I am looking for is, if cell C5=0 then leave blank, if cell C5>0 then subtract 20 from cell C5, and if cell A5 contains...

Hello, I year ago I asked this question and I got a great answer but now I need some help creating a conditional statement within the code: The code below will in its current state insert "x" amount of rows dependent on the specified "row interval." Sub InsertRowsAtIntervals() 'Updateby...

Hi all, I have a question on how to implement a line of code, selecting a specific cell value (and deleting a different one). What I mean by this is the following (see image): I have a range of time data points in a single column (either empty or not, in time format). Whenever there are two...

I posted prior. However, I could not get the solution I was looking for. I have a spreadsheet w/ approximately 40K lines of data. The data is formatted into 3 columns – employee name; week ending; avg. hours worked. Is there a way for me to filter this data in such a way that it omits...

Hello Experts, I need you help to calculate max and min values Based on Designations. Any suggestion please. Thanks, Kamran Noor <colgroup><col><col><col></colgroup><tbody> NAME DESIGNATION PAYROLL SAIRA MALIK ASSISTANT 19,180 FAIZA ALI ASSISTANT 19,970 MUHAMMAD IMTIAZ...

Hi all, I have a spreadsheet with multiple students (males and females) with some scores. I am wanting to create a 'top 5' sheet which shows top 5 males and top 5 females scores. I have found 2 problems with this. 1) Some scores need to be the lowest in the section (e.g. 100m sprint times)...

I am using the following code to add a new row if in any Balance row there are negative value in FGHIJ column followed by any positive value a new row will be insert above the balance row. Similarly I want to add some columns in the code I want to add column KLMNO & PQRST column to the below...

Hi! I have two values in two different cells. For example A1 = 200 and B1 = 512. Now the question is The condition is value of B1 is >= A1 (if condition is false display '0' in the cell) If condition is true subtract B1-A1 (512 - 200). After subtracting I get 312 then I want to find out...

Hi everyone, I have a spreadsheet in which I have created a line graph from containing 9 columns and a few hundred rows so far of data. Example below - (please note managers can have multiple scores on any one day and different managers can be audited on the same date) Date; Area; Event...

I am trying to conditionally format a (fairly) large section using a formula. In the example below, I have rows that may or may not have a total number. If there is a number in the total column, I want the Item name to bold. I am trying to figure out an easier way to format without having to do...

Hi, I need help with a formula that meets the following conditions. Result as “Y” in a cell when meeting all of the following conditions. CA3<200 CB3<230 CD3<ce3*0.35< span=""></ce3*0.35<><CE3*0.35 CF3<cg3*0.1 or="" cf3<1="" (either="" one="" of="" these="" conditions)<=""...

Hi, I need help with a formula that meets the following conditions. Result as “Y” in a cell when meeting all of the following conditions. CA3<200 CB3<230 CD3<CE3*0.35 CF3<CG3*0.1 or CF3<1 <ce3*0.35 <ce3 <ce3*0.35 <cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<=""...

Hoping someone can help me with this one. I've tried the COUNTIF and the IF methods I could think of and I can't figure how to make a simple formula I can put into the cells of a column that will do the following: Consider that Column E needs to contain a list of dates. 1. I need a formula...