if ""

Is it possible that if a specific cell is blank then the desired cell should be blank and if specific cell is not blank then the desired cell should display a picture. I am having such a situation in my result card. I wish if result card shows the "Pass" or "Fail" Status only then the next cell...

I make use of the If statement a lot and sometimes the formula returns a 0. When the main formula returns a zero I want it to show the dash character so I usually make a formula like this: =If(*Formula* = 0,"-",*Formula*) My main question is if there is a way to not have to repeat the formula...

So i have 3 sets of columns with data. How can i write on the right side of excel a formula that would do this IF there is data on Column T, then select that data, if the data is 0 or blank then use column AD, if that column is 0 or blank , then use column AG, if that is 0 or blank just have N/A

Hi, I am having a hard time pulling customers that still need to be listed under column AE. Essentially, if the customer has a green checkmark, it means we are done listing on that customer and any red x's means we have not listed them yet. So I want to be able to come up with a formula that...

Hello, I'm really confused with powerpoint, I basically want to create a table that will automatically assign the price depending on the country I select and the type of the product, I don't want to enter the price manually everytime and I don't really know what to do.. I have dropdowns for the...

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

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

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

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

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