if formulas

  1. H

    IF drop down Question - Adding launch month & year to product forecast

    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 -...
  2. H

    Nine box grid 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...
  3. J

    30-60 -90 Days - IF Function

    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...
  4. B

    Help with IF formula

    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...
  5. B

    Budget IF question

    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...
  6. J

    Rounding formula question.

    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...
  7. K

    IF formula help! pretty please.

    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...
  8. K

    Help! I am getting "you've entered too many arguments for this function- any ideas??

    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...
  9. K

    Help on IF formula, values from 175-260

    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. :(...
  10. J

    Function help, (logic?) assigning a value to a cell based on another

    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...
  11. U

    If Formulas

    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...
  12. T

    do IF statements work on text in Excel?

    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...
  13. E

    If formulas that give the value of another cell

    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...
  14. F

    IF function help

    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...
  15. F

    Conditional Formatting

    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...
  16. D

    Nested if (again .. Sorry)

    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>...
  17. J

    What IF's

    <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...
  18. G

    My IF formulas wont work

    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!

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back