=if

  1. M

    addition of =ROUNDUP, causes function to become 'text' in formula bar

    Hi all. I have a function below which compares two values to two reference cells and works as expected: =IF( OR( AND( AL33 >= $AW$15, AM33 < $ AW$15), AND( AL33 >= $AW$17, AM33 < $AW$17) ),"Y","") However, when I add =ROUNDUP in the formula it isn't recognized as a formula, and instead becomes...
  2. H

    CONCATENATE and IF statements using dates?

    Good day all, I was making a spreadsheet and ran into an issue that I was not sure how to solve. I am using the =CONCATENATE function to write a text string for an email title as well as using =IF statements in it to determine some variable. I ran into the problem when I wanted to reference a...
  3. H

    logical formula without using =IF

    I am trying to create a formula in excel 2007 without using =IF and I am struggling to come up with a solution. Cell A1 is the input cell and cell b1 is another input cell. I am creating a table from A5 to a50 starting with A5=1 The formula I am looking for in row B1:B50 is equal to cell A...
  4. R

    Trying to FIND Neutral Characters to do mass rename in EXCEL

    Ok for some reason when I run my Macros things get moved around in my Manual labels I created. So to get around this I shut down all my formulas in my manual label sheets then rename em back in. Easy solution. But lately I have been running into issues??? I am not sure if it is because of the...
  5. G

    Static cell in a formula

    I am copying the following formula down a column and need the f2 to remain constant instead of canging to f3,f4 .... =IF (OR (C10=0),"",INT (YEARFRAC (C10,F2))) Can anyone help?
  6. G

    Help embedding vlookup in if formula

    Good Evening I'm trying to use an IF formula with an embedded VLOOKUP formula. I need the formula to search the grid for a specific term, and if it matches, use the VLOOKUP. However, if it doesn't match any of the terms, I want it to match the original term it was looking for. The formula...
  7. K

    Excel Formula

    Hi i would like some help with a formula basically if a cell let's say A9 has a value i want the cell to take the value in another cell away (D9) the cell in question is J9 and includes the current formula =MAX((D9-E9+F9-G9+H9-I176),0) Any help welcome Thanks
  8. T

    Excel Formula Question (=IF Function)

    Hi, I am trying to return values of Invoice or Credit Note in column B based on the first letter or digit from column A. The table below shows what the requirements are (E.G M or 4 = Invoice, 7 = Credit Note. However, I'm stuck with the formula below and unsure of the formula required to allow...
  9. N

    IF, TEXT and TODAY() VBA statement

    Hi all, within a macro I am trying to apply an IF statement to a cell. Basically IF the current date = Monday then return the date from 3 days prior, else display date 1 day prior. eg: current date = 4th July 2016(ie a Monday) = result 1st July 2016 (ie previous Friday date) current date =...
  10. G

    IF trouble, don't make me TRIM :(

    =IF(J22="","",IF(G9="","",IF(D10="","",IF(AND(J22<>G9,G9=D10),"Closing Disclosure Interest Rate does not match Note or ELC Interest Rate",IF(AND(D10<>J22,J22=G9),"ELC interest Rate does not match Closing Disclosure or Note Interest Rate",IF(AND(D10=J22,G9<>D10),"Note Interest Rate does not match...
  11. R

    If A2=A1, make B2=B1

    I spent a good bit searching for this answer before I posted, I didn't want to ask something already answered, but I couldn't find the answer anywhere (probably not using the right search terms). I fill out spreadsheets a lot with duplicate information, such as phone numbers. I want an IF...
  12. T

    Skipping rows on an IF statement

    Afternoon all, This will be a simple one for somebody out there but here goes. I have 3 tabs (Summary, sheet 2, sheet 3) All three tabs have the same columns in the same order. However, there is only data in the summary tab at the moment. Name, Address, Town, Telephone number These are...
  13. G

    IF formula too much for my brain

    Thank you for clicking on my thread. I'm fairly proficient at Excel formulas; however, this one is just becoming too much. I feel a fog settling over my brain. :) I have three fields: D10, G10, and J10. All three will have dollar amounts manually entered, and I need a formula turning out...
  14. B

    IF command Help

    Hello, I’m attempting write a funky IF command to construct the matrix below and I’m stuck. This is what I'm trying to achieve. I know it's a combination of IF and perhaps the RIGHT functions, but I can't seem to put it all together correctly... <tbody> Species 1 (1) Species 2 (10)...
  15. G

    IF COUNTA conversion to VBA

    Morning All, Can anyone help convert this into VBA for me? I need it to automatically run as the worksheet is filled out: =IF(COUNTA(M1:V1)=10,TODAY()+60,"") Currently used in column W Thanks in advance.
  16. S

    Complex IF Function with Different Data Types

    Hello all! Trying to pull something off here, but I'm not sure if it's possible. Below, 11/8/2015 is A9, 21 is C9, and 23 at the bottom there is C18. <tbody> 11/8/2015 Wordy 21 33 11 4.5 4.5 4.5 Max 10 300Editors 7 11/9/2015 Wordy 9 23 </tbody> From 21 down to...
  17. M

    2 Vlookup's based on a variable?

    Hoping someone can help me here! As stated on the title, I'm trying to create a formula that will use either one of two VLookup formula's based on a variable that is in play. =if(B3="Company1", (=vlookup(G3,'Table worksheet'!A:F,6,FALSE)), (=vlookup(G3,'Table worksheet'!A:F,5,FALSE)))...
  18. A

    Help with IF formula containing multiple conditions + number ranges?

    I have been working to create a formula to work out sales commission from sales targets. So far I have this formula: =IF(B13<B11*0.70, B13="0"),IF(B13=(B11>=0.7,B11<0.99, B13*0.075))) Any idea why it isn't working? Thanks,
  19. C

    Nested =IF(ISBlank)

    I am trying to pull data from multiple columns from a survey via google forms some of which are blank and some of which have a text. There is only one cell with text for each row in columns H-N. In rows H-N there is one cell with text per row. I'd like to be able to pull each of the text's...
  20. R

    excel formula for search

    I need a formula. Cell A19 contains 'JR', note that it will not always contain JR so I need the formula to use the contents of the cell no matter what it changes to. I am inserting a formula into cell E19 that is to search cells B3, B4, D6, D7, D8, D9, D10, D11, D12 & D13 for the text that is in...

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
Back
Top