ignore formulas

  1. K

    Data entry question in Excel

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  2. S

    Copy paste ignoring formula returning 0

    Hi All, I have a mock-up general journal template, this will copy and paste items from sheet1 to sheet2 and increment a unique reference. I’m happy with all the functionality up to there. The issue: column B generates a reference using a formula based on entries in column G. Until a value...
  3. J

    Get Dyndamic Charts to Ignore Formula

    I'm running a chiropractic office. In order to see where I've been and where I'm going I keep track of things like new patient visits, patient report visits, cash in, insurance in, etc. I keep track of this on a daily basis on one worksheet. The weekly totals are paste-linked into another sheet...
  4. girapas

    Check if a cell has data ignoring the formula in it

    I want to enter a formula in A2 to calculate A1+10, if the B2 has data and if it hasn't to leave the cell blank. The cells B1 and B2 have formulas that update from other cell. The following formulas don't work when I use them in A2 (I suppose due to the existence of the formula in B2)...
  5. T

    ignore formulas

    I have a macro that selects all cells that have data in a column. the only problem is my cells have a formula and it selects these as well even when the formular results in "" formular in the cell is =IF(B13="","",C13&","&B13) Macro is Range(ActiveCell, (Cells(65536...

Some videos you may like

This Week's Hot Topics