if formula

  1. Jyggalag

    Get formula that pulls a number from a sentence in a cell

    Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...
  2. E

    VBA 4 conditions have to match if matched then write the word "TBC" into desired cell.

    Hello, I have been trying for a few days to figure this out, however I have run out of solutions and formulas to complete this. I have two sheets and would like to find the value from sheet1 column 1 in sheet2 column 3 and also sheet1 column 2 in sheet2 column 11. If all matches then I want...
  3. bradjsteve88

    Clear formula to track invoice status

    I am trying to get a formula like the below that works backwards through a table, i.e. IF N6 contains date="Paid", if false check M6, IF M6 contains date = "Invoiced" and so on. =IF(N6>0,"Paid"), IF(M6>0,"Invoiced") IF(L6>0,"Accepted") IF(I6>0,"Submitted")
  4. Jyggalag

    Implement IFERROR formula for data in Pivot Table?

    Hi all, I have this data sheet: I have turned it into percentages and I assume that the top value (0.36% & -1.52%) are the sums of my columns (I am very new to Pivot, sorry). But I have #DIV/0! errors! :( Is there a way in which I can implement an IFERROR formula for my entire pivot table...
  5. Jyggalag

    Save file as PDF in VBA (macro)?

    Hi all, I currently have the following setup: I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF. However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...
  6. E

    Modify array and include 3 conditions in formula

    Good day, Some time ago, I was helped through this forum with creating a formula for my boss' product prices but now he wants it to be modified. The current formula is this...
  7. J

    Problems With an "If" Formula

    Hi. I recently lost my job, and am returning to the world of Self Employed, in a service business. As part of setting this business up, I am creating a flat rate pricing system so that I can quickly and easily update my pricing, while giving a visual aid for selling from the customer...
  8. U

    VBA / SumIF formula / Pivot Filters

    Hello Gurus, Hope you had a nice weekend. I was trying to find a way on how to show the "Count of Indicator" but can't figured it out on Pivot. I was thinking that if it won't work on Pivot maybe IF formula or VBA would be helpful . Raw Account Country Data Score Indicator (value after...
  9. U

    VBA: IF value greater than and less than

    Hello Gurus, I'm getting a syntax error on this part of my code. Anyone who can help me tweak the code below? = = = = Sub Check With Range("Z2") .Formula = "=IF(Z2<0,"Less",IF(Z2>0,"Add",IF(Z2=0,"Zero")))" With .Resize(Range("A" & Rows.Count).End(xlUp).Row - 1)...
  10. E

    Round last integer to the nearest value from a list

    Hi, my boss wants me to create a formula for the prices of his products. He wanted all prices below 99.99 to be rounded up to xx.97 and the values from 99.99 and greater to be rounded up to xx.00 and I have managed to put together a round formula like this...
  11. N

    Multiple IF formula functions help

    Hi, I need help with the if formula. I got a basic formula down but now I need to add multiple functions to it and am getting stuck. This was the formula I was able to get for column CN: =IF([@[Years of Service]]*[@[Severance Weeks per Policy]]>[@[Min Weeks]],[@[Years of...
  12. M

    Use Conditional Formatting to to Highlight Cells with Specific text and IF formula condition

    I have 3 cells that I am looking at: Contact Name Name Word Count Name Fix John John Doe 3 John Doe Bear Bear Joe 3 Bear Joe What I need is to run Conditional Formatting formula to highlight the CONTACT NAME column if the number in the NAME WORD COUNT column is equal to 3 and if the...
  13. G

    If Formula Run-time error

    Good day, I've got this VBA code below that I'm trying to do but I keep getting a 1004 Application-defined or object-defined error. It works fine without the IF statement so I'm not sure what the problem is within the IF statement itself. Sheets("Sheet1").Range("E24, H24, K24, N24, Q24, T24...
  14. M

    How to set an importance value of multiple variables?

    Hi guys. I'm a bit new in VBA coding, but have worked with Excel a lot. I have this Claim sheet I am working on. And I need the Claim Importance to show (Low, Medium, High) on multiple variables. My formula right now is...
  15. S

    Formula to find if there is a carrier return in a cell

    Hi, We have a column of emails for employees. Is there a formula to identify if there is a carrier return in the data? Say the email addresses are in column A. I tried to look for a formula but I had no luck.Sorry we are looking for a return of YES in column B if there is a carrier return else...
  16. Jyggalag

    Excel not showing blank in formula when I want it to

    Hi all, I currently have this formula: Right now the cell is showing a blank cell. I then have another cell that links to this cell through this formula: This cell also shows blank, because the first cell is blank. I then have a third and final cell with this formula: However, this...
  17. J

    Substitute All Except

    Hi, everyone, Is there any way to substitute a character or series of characters from a cell with other characters, but with some exceptions? For example, substitute (or replace) all instances of "X" in cell B1 by cell A1, except "XP", "Xbox", "Xochitl", "Xmas", and a few others. I had written...
  18. N

    IF formula based on text selection of another cell

    Hi guys, I'm not that good at Excel but I've been tasked with making some improvements on a document. In this case I am looking to create IF formulas (I believe that is the right one?) to show certain selections (competencies in this case, it's for recruiting) based on the position level that...
  19. T

    How to insert string into an if formula?

    Hello users on MrExcel. I am still a Newbie at VBA, so this question might seem a bit dumb, but i have tried to find a solution for the past 2 days, on and off. Lets just say, for the ease of it, that i have a Cell with the symbol ">", and it can change to "<" The cell i defined as "s" and...
  20. M

    Applying specific discount dependent on SKU type

    Hi! I have a pricing file where i have various SKU's which are in the type ABC-XXX, AD-XXX & GE-XXX (could also be more but using these as examples). Each SKU has a price. I have another tab where i have listed what the % discount should be depending on the SKU type but don't know how to get...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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