if(

I am self taught and don't always know the right way to ask the questions to google. 2 days ago I posted my sumproduct formula and with help it worked perfectly. Now I am trying to add an IF for a zero return, (which is ok, I need the zeros to populate), but if it is not a zero, I need it to be...

I am currently averaging values in one table based off of their rankings in a separate table. I am doing so for each combination of the potential rankings. The formula below works for this purpose. =AVERAGE(IF((Table2[ranking]=B2)+(Table2[ranking]=C2)+(Table2[ranking]=D2),Table3[Value]))...

I have a program that I am require to use that outputs data horribly and makes it very hard to see the big picture for where everyone is for their certifications. I output everything into a CSV (only way I can) (Qualifications). I am trying to get the data to look more presentable so I can see...

Hello - I am looking to create a formula that will return 'YES' or 'NO' based on different factors.... Without going into detail on the other parts of the formula unless necessary, the entire formula works until I added the bolded section below...

Hi All, I'm processing camera data on a citizen science platform where each image has to be classified three times before being retired. In this instance, I want to know which are retired, and which are not. Those that are not retired are listed as null in a string, and those that are have a...

I am trying to find a way that can automate using a number of ranges. For example Ex. If cell A1 is 25-45 A2 is 6 if cell A1 is 45-65 or 15-25 A2 is a 7 If cell A1 is 100-150 or 4-8 A2 is 10 How would a create an IF formula to do this? Or is there another formula that would be better?

Hello, I am trying to automate some parts of a spreadsheet. Essentially I have 2 Cells for example A1 and A2. In cell A1 I would enter a number in it anywhere from .01-100. And in A2 I have to rate it a 1 - 5 based on ranges. So if ex A1 = 1-25 it's a 1, 25-49.99 is a 2, and other ranges. What...

Hi all, hopefully this will be a simple one for you. I am looking for a formula that I can put in a table to do the following. Sheet1 Column C has a list of my products. Column E contains the date the goods were received. (For some reason, and it is unavoidable unfortunately, the report the...

Hi all, thank you in advance for your assistance. I am preparing a product performance tracker for the business but I am having a lot of trouble with one little piece. On Sheet 1 Column E I have a list of all the products. Sheet 1 Column I contains the Product Category. The category has 3...

Hello, I have two sets of addresses. In one column there is a set of non duplicate house addresses. The second column has the mailing address of the owner of the house. I need to send letters to the home owners using a mail merge. <tbody> Physical Address Mailing Address 1929 55 AVE S...

Hi I wonder if anyone can guide me please. I have 3 Sheets that an item moves across depending on its delivery progress, therefore is should only ever be on one Sheet. I then have a Master Sheet to have an over sight over all items, which will also then be used to gather further data (I will...

Hi, I'm looking for a solution or a formula which could solve my problem. [/URL][/IMG] I want the "STATUS" column to be populated as per the value available in "COUNT" column which is always a numerical. All the "STATUS" should state "PR" if any of the cells in range "COUNT" corresponding to...

i need a formula that reads a SKU number in column 1, reads column 2 to see how many times it will be listed in 3rd column. As you can see below, SKU A appears in Column 1 and the quantity in Column 2 is 1, so it only listed in the 3rd column (print) 1 time. But SKU B has 2 quantity so it is...

The title of this post is confusing as heck, so I apologize for that in advance! I know there's a way to do what I'm looking for (there's always a way), but I'm having a hard time with it this morning. I'm hoping you guys can help! I'm looking to create a formula that will show, in the cell I...

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)<=""...

I have a cash-flow which I need to calculate how much interest is paid each month to the day. The interest is built up over the first 6 month then the total accumulated is paid on the 7th Month then the interest is paid on a monthly basis thereafter. I am currently doing this by using an IF...

i need the if function to work as follows: if(d2<d3<d4,ae1+af1,ag1)<d3<d4,ae1+ad1,af1) <d3<d4,ae1+af1,ag1) if d2 is less than d3 and d3 is less than d4, if true then add ae1 to af1, if false then show the value from cell af1 it doesn't seem to work. what can i do to get the results i...

Hello, New poster here and I apologize if I do it wrong but I could really use some help. I made an Excel spreadsheet on my Mac with 2011, which has the ability to nest as many IF functions you want, and I need it to work on my office computer which has Office 2003. The formulas are simple...

Hello, I am trying to use the following formula: =IF(E31<=E27, J27,IF(E31>E29, $J$29, IF(E31=E28, $J$28, IF(E28>E31>E27, ((E31-E27)/(E28-E27))*$J$28, IF(E29>E31>E28, ((E31-E28)/(E29-E28)*($J$29-$J$28))+$J$28, ""))))) It works except for those values that fall in between two numbers, in this...