Results 1 to 8 of 8

Default to a backup value if one cell is blank

Threaded View

  1. 03-05-2017, 09:03 PM #1
    khr0n0s
    khr0n0s is offline
    Registered User
    Join Date
    01-31-2017
    Location
    Philippines
    MS-Off Ver
    15
    Posts
    18

    Default to a backup value if one cell is blank

    Hi experts,
    I'm having trouble on how to show the value in C2 if there's no value in D2.
    Please look at the sample that i attached in here.
    F2 should be 15 not 0.

    Adding Reputation to you is all i can do for helping me
    Attached Files Attached Files
    Last edited by khr0n0s; 03-05-2017 at 09:21 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. New, 'Blank Workbook' opens with Excel default seetings, not my default book.xltm settings
    By Mscool1967 in forum Excel General
    Replies: 3
    Last Post: 10-16-2013, 07:17 AM
  2. Default text in 1 cell when blank - to remain once subsequent text deleted
    By thedude1222 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2013, 08:45 AM
  3. [SOLVED] How to make a dropdown list cell default to blank, after another cell selection is made
    By chardsmith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2013, 03:46 AM
  4. if cell is blank, can u make it say something by default using a formula?
    By teenyjem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-07-2012, 01:04 AM
  5. Drop down list set to default sum but blank when row is blank
    By debbiesh in forum Excel General
    Replies: 4
    Last Post: 02-20-2012, 02:24 PM
  6. Prefill MonthDate,Clear cell & Default to last blank cell
    By SVTF in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-17-2011, 10:08 PM
  7. Display 'Date' cell as blank instead of default year 1900
    By charger100 in forum Excel General
    Replies: 5
    Last Post: 11-19-2009, 05:21 PM
  8. [SOLVED] Backup:always create a backup file in the save options
    By Alek in forum Excel General
    Replies: 1
    Last Post: 01-07-2006, 09:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1