and if

Hi, I have a long sequence of numbers running horizontally on one tab of a worksheet. I want to paste this set of numbers into a grid on a separate tab, if the column ref = the row ref ONLY IF the value in column C > 0. It should look like the below, so as you can see if column C (to the...

Hi all, What I want to achieve is this: Display me a set value e.g. 10, every time that EITHER condition A or condition B are met, UNLESS a given cell = 0. To give some context, this is relating to deliveries of a product. I am forecasting the costs incurred over a period of years where...

Hello....Thanks in advance for helping me out... I've been trying for the last few days to figure out how to calucate winning streaks in excel. I've seen postings on this website that have been help from a broad perspective but I need more specific help. I have the current schedule of a fantasy...

Hi, Need some help fixing a CSE formula with multiple nested conditions. Formula is: {=COUNT(IF(AND($Y$2:$Y$37263<1,$D$2:$D$37263=AC18),$V$2:$V$37263))} Just returns a value of 1 when it should return something in the order of 3000. What I want it to do is count the number of rows in the...

Hi, I have created a formula that calculates the age of a person based on the date entered: =DATEDIF(B9,TODAY(),"Y") =DATEDIF(B9,TODAY(),"YM") and then i put the data into another cell: =VALUE(AA8)&"."&(AA9) so for example i have the age of 4.5. Then I want to see if the age is between which...

I have two sets of example borehole data. First, a range of depths with varying confidence levels. <TBODY> ID</SPAN> From depth</SPAN> to depth</SPAN> Confidence</SPAN> PZ1</SPAN> 0</SPAN> 5</SPAN> High</SPAN> PZ1</SPAN> 5</SPAN> 7</SPAN> High</SPAN> PZ1</SPAN> 7</SPAN>...

Hello People, I have one (middle) column of numbers and I want to have a running total as a certain pattern appears as shown in the numbers below: <tbody> 91 91 92 93 94 94 3 95 96 96 2 97 98 99 99 3 100 99 99 98...

Someone please help me with these formulas! I am so upset I can not figure these out. PLEASE HELP :( 1. Enter a formula to calculate the number of gallons billed, based on the following rules: If a customer's bill is waived (Bill Waived column) or the number of gallons used is less than 25,000...

Excel 2003 Current formula =IF(B6<=80,B8+J3,IF(B6>80<161,B8+J4,IF(B6>160<241,B8+J5))) I need the object cell to display the sum of B6 and one of the 3 conditions, which ever one is correct. All I can get is FALSE.