blank cell formula

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. D

    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...
  9. 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
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. C

    Formula to leave the C1 blank if either A1 or B1 (both containing dates) are blank

    I am attempting to calculate a total value for a column in which I have a formula giving the number of days between two dates. Example: A1 start date, B1 end date C1= number of days between. I need this formula to leave the C1 blank if either A1 or B1 (both containing dates) are blank. Does...
  16. A

    Filling blank cells in a column with a formula after inserting rows

    Hello! I am working on a flowtable of flight planning and obviously there is a lot of itineraries that are moved around, hence a lot of deleting rows and inserting rows. the deleting doesn't make an issue - it's the inserting that does! to the right of all the schedules, there are columns...

Some videos you may like

This Week's Hot Topics

Top