if formulas

Hi everyone So I posted in here a few weeks ago and someone wrote me an excellent VBA which cuts and pastes rows to different sheets depending on what's written in column F of my workbook. The code is as follows: Sub sort_my_data() 'VBA written by SQUIDD from MrExcel.com...

Background - I am creating a 3 year revenue forecast for a product that is to be launched. The forecast starts with the raw number of customers in each market, and then applies cuts based on assumptions as you move down the model, finally ending with revenue and volume as the output. Problem -...

So, I have a nine box grid for a talent management colleague. They have a mirror of this on a separate sheet, the 9 box itself has a countif formula which pulls from objective data. I want to input a formula in all boxes in the mirror to return the name of the person which is inputted at the top...

Hi I am trying to do a function where if invoice is 30-60 days the cell will say30 - 60 days, if invoice is 60-90 days, cell will say 60 to 90 days and if invoice is over 90 days, cell will say Over 90 Days. Here is the formula I have put it =IF(H3>29,"30-60 Days",IF(H3>59,"60-90...

Hello, I am trying to create a formula that substracts dates and if result (in this case moths) is higher than 12, I want it to multiply it by cell "T8" or do nothing if result is less than 12. Below is the formula: =IF((YEAR(P8)-YEAR($V$4))*12+MONTH(P8)-MONTH($V$4))-12>0,*T8,"")) Any advice...

Okay guys. Here is a crazy one, but I am building some amazing personal budgeting sheets. First, an explanation of what I am trying to do. I have a row of numbers in 3 cells. 20 -20 0 20 is what I budgeted to pay of a debt. -20 is what I owe on the debt. (retrieved from a cell in...

Hello everyone! I own a bakery and I'm trying to create an ingredient inventory sheet. Each night I have a sheet that updates automatically how many dough batches I should make. The batches must be whole numbers since I can't make a half batch of something with the large mixer that I'm using...

Hi There I have a formula for rates that works =IF(B4<350000,1100,IF(B4<750000,4.179,IF(B4<1500000,4.104,4.028))) which is based on the Revenue entered in (B4) - it assigns the correct rate then I have the price (B9) set to multiply by (B4) to get the price HOWEVER for revenues of under 350000...

Help. I am getting "you've entered too many arguments for this function". Does anyone know how to add more? I am trying to use: =IF(C5<1000001,C15,IF(C5<2000001,C17,IF(C5<3000001,C18,C19,C20,C21))) for the $1.5M , $4M & $5M option but it won't let me add C16, C20 & C21 for column one...

I have values in a worksheet that are from 175 - 260 and I want to but a score on them in a separate column (B). values of >= 260 will be 50, 200-225 will be 45, 175-199 will be 40. Here is my formula, and it is only putting a value in cells that have 260. everything else is getting 0's. :(...

Hello, I am trying to fill in the Net height in the below table based on the Net assignment located next to species. If Net=A then Net height should = 2.6 for MYLU but should be 10.4 for MYSO. I've tried a nested IF function =IF(B1="A",C1 IF(B1="B", D1)) but it returns an error. I could do it by...

Hello everyone, I'm new to this website and need some assistance. My "IF" formulas are too long and won't work due to nesting? This is the formula I have came up with. =IF(ISNUMBER(SEARCH("12",SHEET1!A1)),"730A-8P",IF(ISNUMBER(SEARCH("8",SHEET1!A1)),"",))) but if I don't have a 12 or an 8 I just...

I am trying to use an if statement on a cell that contains text so it looks like this: =if(D2="fun",no,yes) and it returns #NAME? I have made sure that the field's format is text, have copied and pasted the data a few different times and ways (paste value, straight paste...), have tried with...

Hello, I have two columns. A is full of numbers, and B has some numbers and some blank cells. I want a formula for C1 that says 'If B1 is blank, use the number in A1. If B1 isn't blank, use the number in B1'. So, for example, the end result would look like this <TABLE style="WIDTH...

I have a large spreadsheet I'm working on and here's what I want to do: IF a particular cell has "x" value in it, then I want to multiply a corresponding cell with a pre-filled in dollar value by .45 and place that calculation in a different cell. Example: If cell A1="636" then multiply the...

I previously asked how to do IF statements for multiple cells. The second part of my question is how to apply conditional formatting to that cell. So.... If I'm using the following formula: =IF(AND(E13>=6.5,E14>=6.5,E15>=6.5,E16>=6.5),"Meets Criteria","Does Not Meet Critera") How can I have...

Good Afternoon Ladies and Gents (Excel 2003 (XP) user) trying to nest up a few IF Formulas into one equation IF(AND(B56=FALSE,B57=FALSE,B58=FALSE), “TICK PRICING OPTIONS”, “ ”)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...

<TABLE style="WIDTH: 428pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=568 border=0 x:str><COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" span=4 width=74><COL...

Here is what I would like to do: Anytime there is a 1 in column B, I would like for columns G-I and columns L-N to display "N/A". I have tried all kinds of formulas, none of which will work. Is there any way to do this? Please help!