if ""

  1. S

    IF(LEN) Function

    Good morning all, I have the following formula on one of my spreadsheets, written by an excel wizard. I am trying to figure out what exactly this is doing. I know what the functions do individually, but not like thiis. Any help will be much appreciated, and thank you in advance to taking the...
  2. J

    Tough Inventory Question

    Hi! I run a tennis club and I was hoping to use excel to track some of my inventory. Basically, I have 10 pros. They each use a set number of items. For example, I use 2 cans of balls, 1 set of strings, and 3 bottles of water per lesson. Each coach has a different number, but I was wondering...
  3. O

    If specific text in cell A, then current time + other time in cell B

    Hello, We have a simple break list at work. I spent a lot of time making a better one, but the manager said it's too complicated. I want to improve the one we have now at least a little. (screenshot attached) In this break list, when you click on a cell under the "status" column - you have 4...
  4. F

    IF Statement Problem

    Good morning, I have been struggling with an IF formula I’m hoping someone can assist me with: Issue - I have three different billing options: 1. Yes – Midwest 2. Yes – NE/SW/CAN 3. No What I need for my formula to do is to look at the above three options in cell “I2” if the result in the...
  5. pedie

    Please modify my current code! If any of the cell from A3 to F3 is "" then exit sub

    If any of the cell from A3 to F3 is "" then exit sub, how do we set this up?:) Thanks Pedie Current Sub CommandButton2_Click() If Range("b3") = "" Then MsgBox "You must assign a Detail Number in cell B3" Range("b3").Select Exit Sub Else Run "Report" End If End Sub

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
Top