+ Reply to Thread
Results 1 to 3 of 3

Ignore Formula if Cell is blank

  1. #1
    Registered User
    Join Date
    03-06-2018
    Location
    Kansas City, MO
    MS-Off Ver
    Excel 2016 - Mac
    Posts
    1

    Ignore Formula if Cell is blank

    I am a not very advanced at all with excel. I am working on a project that I am needing this formula to not work if one of the cells is blank.

    =(P10-D6)*P9
    This is what I have, which works great if all cell values are entered. If a cell is blank it calculates and gives me a number I don't need to have displayed.




    Any and all help would be greatly appreciated.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,834

    Re: Ignore Formula if Cell is blank

    Give this try

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by shukla.ankur281190; 03-06-2018 at 01:37 AM. Reason: Missed one criteria
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    Re: Ignore Formula if Cell is blank

    welcome to the forum. which of the 3 cells needs to be blank to return a blank? if it is just P10:
    =IF(P10="","",(P10-D6)*P9)

    if it could be any of the 3:
    =IF(OR(P10="",D6="",P9=""),"",(P10-D6)*P9)
    =IF(COUNT(P10,D6,P9)<3,"",(P10-D6)*P9)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Ignore blank cells with formulas or ignore NA() in a formula
    By guiismiti in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-24-2016, 02:13 PM
  2. [SOLVED] Sum formula ignore display cell blank
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2014, 07:24 PM
  3. [SOLVED] VLOOKUP Formula - Needing it to ignore blank cell
    By sstravs in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-18-2013, 04:12 PM
  4. [SOLVED] Formula/Concatenate to ignore a cell if value is blank
    By karimel_romeo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-13-2013, 04:26 PM
  5. Ignore Cell if it is blank (but still has formula)
    By thelegazy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2013, 12:30 PM
  6. Formula (SUM & IF) to ignore a blank cell?
    By DORourke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2013, 06:48 PM
  7. How? Ignore cell if blank in an IF formula.
    By n2lectual in forum Excel General
    Replies: 7
    Last Post: 03-26-2008, 03:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1