blank cell formula

  1. F

    Colour all blank cells in a row if one cell in row has text.

    Hello, New to this site so apologies if this has been covered before and I just don't know how to search for the answer. I want to use conditional formatting to make blank cells yellow in any/all columns if there is text in column A. For example, column A could be order numbers, column B could...
  2. J

    IF cell contains multiple text return "Pass", "Fail" or "" (blank)

    I've set the below formula. It works great when Activity 1-3 have been selected for Pass/Fail. =IF((AND(D20="Pass",D21="Pass",D22="Pass")),"Pass","Fail") However, if the Activity section hasn't been filled out yet (or are blank), the Outcome in B35 - B37 default as "Fail" If the criteria...
  3. H

    Dynamic named range for invoice data

    HI, Newbie to excel here. I am trying to use code to take a named range on an invoice and add it to a database in a separate sheet. The code I am using is below but need it to not pull any blank cells that contain functions in them. Code I was previously told to use but has an error...
  4. M

    Get value based total column in range minus Blank columns

    Hi. I have data in range from Columns G to R. I have value "a" at column J and then 2 Empty Columns. After them I have data at column M and formula give me value "d" but I want to be "b". Also for Column Q, I have "h" but I want "c". If I have Data, this is my formula at Column M( change Column...
  5. M

    Only calculate formula if cell is not blank

    In one column I have a date field. If there is no date I don't want the other columns to calculate the formula, using VBA. Column c: 1/20/20 Column D: "formula is column c +21 days column E: "column d minus today. its all based on the date field in column C.
  6. F

    Formula to blank to formula

    Hi I have the following formula in a cell, which works great, and turns what is in the cell blank, if a 0) is subsequently put into cell a23. However there are times when I then need to then change cell a23 back to a different number, so I then want the formula to kick back in ...... Problem...
  7. D

    Copy/Paste Range issue with VBA when cells are empty (but with formulas inside)

    Hello, Currently having some issues when copy/pasting some range of rows. There are some formulas in there that would be populating depending of another table. So in the end there would be some rows populating from such table, and eventually remaining rows without populated values would remain...
  8. M

    Making a cell blank whilst keeping the formula nad the conditional formating

    Hi. This is my first question sorry in advance. So I hae two clumns C and D, D is my expiry date column and C is my start date column. I have formated D to turn orage or red depending on the time left. I also have the formual =EDATE(C3,6). The problem s that because nothng is acctually entered...
  9. C

    SUMIF blank cells containing formula

    Hi all Probably a very simple answer, but I have a series of SUMIF cells which all work perfectly, until they reach a blank cell which contains a formula. I can't find the right syntax for the SUMIF to work, any ideas? The code at present is: =SUMIF($AI$2:$AI$328,"",$AD$2:$AD$328) Where...
  10. B

    If then-formula

    Hi Everyone, first post here. I couldn't find anything on it. I want to have a running total of two columns showing in a third column, which I was able to do with the following that I found in another post: =SUBTOTAL(109,$D$3:D9, $E$3:E9) my problem is that after my last row with data, it...
  11. B

    Ignoring blank cell in complex Sum formula

    Creating a title for this was tricky. So I have a spreadsheet in Google Sheets where I have three sets of data that I need to add together but there are times one or two of the cells might be blank. Basically, I am trying to create a Score for a call center rep where a call is worth 8 points...
  12. G

    graphing over blank empty cells ... i.e., skipping blank cells

    I have created a graph to show readings over time and I use the option to skip over empty or blank cells. Problem is that my formula to create empty cells is not creating truly empty or blank cells. The example formula is =IF(A1=3,A1,"") ... The =IF statement checks cell A1 and if it finds...
  13. R

    Formula to populate following cells based on previous cells

    Hello, I am trying to figure out a formula that will help me populate cells based on the sample instance below. I've tried different IF statements but can't seems to get it to work right. Any help is greatly appreciated. Thanks! <tbody> Name (current) Name Populated All the Way down...
  14. L

    Show Blank Cell Unless...

    Trying to setup a closing date calculator. The formulas are easy and are working fine, but when I convert this to be added to a website, it populates a date with year end '00 in A7 & A13. How can I make the cells show as blank until until A3 and A10 have values selected? Select Contract Date...
  15. I

    Please Alter this with an (IFBLANK) command?

    When I copy this code to the cells below it, IF the reference Cell is empty it puts dates in all the cells (exp. 1/1/1900) how can I safely Convert these formulas into the IF CellBlank Fomula? HERE IS THE FILE : http://www.filedropper.com/accrualscalculations
  16. A

    Excel formula will not account for empty cells

    Hello to everyone on this forum! I am so glad I found this because I am pretty stuck. Here is my problem: I have a list of names on one excel sheet, I have a formula that takes whatever name is typed into a particular cell and checks the number of times that particular cell appears across a...
  17. J

    Fill all the cells in a column with formula

    Hey guys, I need some help with the If function in VBA. I need to put a formula in every empty cell in a specific column and I can't manage to define the function. My code is this (but it doesn't do anything): For Each cell in Worksheets("Sheet1"). Range("L5:L" & Rows.Count.End(xlUp).Row) If...
  18. L

    Why is formula calculating a blank cell?

    PROJECT DESCRIPTION: I am making a time sheet. Rows 32 and above list the hours I have worked in a day. Each row represents a day. Each column represents a different castigatory (vacation time, hours, overtime, sick time, etc.). Row 34 lists the $ I earn for each category. I am using column M to...
  19. T

    Unique list out of non-unique row

    Hello everyone! mrexcel has been my top resource when it comes to Excel-related questions. Great to be a member now. What follows is a tricky combination (for me, that is) of - starting from several rows named "A", "B", ... with blank cells, zeroes and values larger than zero in columns named...
  20. A

    Dynamic Charts with "Blank" Cells Containing Formulas

    Hey everyone, this is my first post! I've figured out how to create a dynamic chart, where the last values of my data are forced to be blank using an IF formula. The range that I created for which this works has the following formula...

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