+ Reply to Thread
Results 1 to 4 of 4

If Blank, Blank. If not blank =?

  1. #1
    Forum Contributor
    Join Date
    02-28-2020
    Location
    Inverness, Scotland
    MS-Off Ver
    365
    Posts
    308

    If Blank, Blank. If not blank =?

    In cell K18 I have this formula
    Please Login or Register  to view this content.
    However I want K18 to remain blank (it currently shows Operating Costs'!$X$6) until there is text in E18, I have tried to do it with IF & ISTEXT but must be missing something
    or it can't be done. Grateful for any help. T.I.A.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,929

    Re: If Blank, Blank. If not blank =?

    Try this:

    IF(E18="","",IFERROR((('Operating Costs'!$X$6)+($H$6*G18)+P18)*IF($F$8="Y",1.2,1),""))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    02-28-2020
    Location
    Inverness, Scotland
    MS-Off Ver
    365
    Posts
    308

    Re: If Blank, Blank. If not blank =?

    AliGW thanks so much for quick response, works perfect. :-)

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,929

    Re: If Blank, Blank. If not blank =?

    My pleasure!

+ 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] G Sheets: Count 1 per row IF Col D <> blank but Col E = blank OR F <> blank but G is, etc.
    By reinmcha in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 08-18-2020, 04:09 PM
  2. [SOLVED] Create multiple blank rows and adding a formula in the first newly created blank row
    By Ratso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-20-2018, 11:23 AM
  3. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  4. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  5. Mac Excel: Hiding rows if cell blank, when being blank depends on a conditional formula
    By lee_5_5 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-06-2013, 11:25 PM
  6. [SOLVED] Simple pull exact text from cell, if blank it pulls up a 0. How to leave it as blank?
    By sharpmel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2012, 02:20 PM
  7. Replies: 1
    Last Post: 03-21-2012, 09:41 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