50 results
Open links in new tab
  1. VBA IF Statements: Can you have multiple actions in the "Then" area?

    Jan 26, 2011 · I can't figure out how to have multiple actions occur in the "Then" area of a VBA IF statement. I am trying to set 2 …Read more

  2. If statement not recognizing number | MrExcel Message Board

    Feb 20, 2010 · Hello, I am having trouble with a IF statement in Excel. Here is my statement: =IF(C11=400063,G11) I am saying If …Read more

  3. Multiple IF Statement but with a priority. - MrExcel

    Dec 17, 2008 · What i'm trying to do is write a multiple if statement that says if one of the cells has F1 or F2 then "Fail" if the cell has …Read more

  4. Using an IF statement to populate a TEXTBOX - MrExcel

    Jul 30, 2013 · SOLVED - Using an IF statement to populate a TEXTBOX JLeno, thank-you. Problem solved. The main thing I am …Read more

  5. Nested If Statement Returns False instead of a value - MrExcel

    Oct 28, 2021 · Excel Facts Highlight Duplicates Click here to reveal answer Home, Conditional Formatting, Highlight Cells, Duplicate …Read more

  6. Combine Round with IF statement | MrExcel Message Board

    May 26, 2011 · I have an if statement that is giving me a value, let's say 29, but I wanted it rounded to the nearest 5 - in this case, 30. …Read more

  7. Check text color in an IF statement | MrExcel Message Board

    May 19, 2011 · What I need to do is check to see if a cell has a certain text color then provide me a true statement. In B2: …Read more

  8. Multiple Conditions in IF - Excel Tips - MrExcel Publishing

    Sep 13, 2017 · Learn Excel from MrExcel podcast, episode 2025 - Multiple Conditions in IF! I'll be podcasting this entire book, the “i” …Read more

  9. IF Statement returns 0 instead of blank - MrExcel

    Aug 15, 2013 · Hi everyone I have a simple IF statement that returns a 0 when the criteria is not met instead of blank ""...Read more

  10. Combining an IF Statement with multiplication - MrExcel

    Jul 24, 2013 · Greetings, I am trying to find a formula that will allow me to do the following: If the value in A1 = 'A' then multiply B1 by …Read more