+ Reply to Thread
Results 1 to 7 of 7

Multiple cells blank using formula for result

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Multiple cells blank using formula for result

    Hi

    Can someone assist with the following formula request.

    If cells F4,G4,H4 are all blank, then the outcome is Yes, if not then the outcome is No.

    I've been trying to use an if(OR statement but can't get it to work.
    thanks
    Last edited by Christopherdj; 09-24-2014 at 06:37 PM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Multiple cells blank using formula for result

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Multiple cells blank using formula for result

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Multiple cells blank using formula for result

    Works, thanks but I did not communicate my query properly.
    If any of the cells, F or G or H, not all 3 at once.
    Can you amend the formula to suit?

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Multiple cells blank using formula for result

    Do you mean?



    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Multiple cells blank using formula for result

    Do you mean?



    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Multiple cells blank using formula for result

    Yes, thanks - seems to resolve my issue.

+ 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. Replies: 12
    Last Post: 09-19-2014, 10:18 PM
  2. Replies: 2
    Last Post: 10-18-2013, 11:18 AM
  3. Replies: 5
    Last Post: 08-26-2013, 06:26 PM
  4. [SOLVED] Need help with SUM formula (multiple cells) that shouldn't leave result trail
    By aalim95 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-26-2013, 06:17 PM
  5. Replies: 4
    Last Post: 06-24-2013, 07:17 AM

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