Results 1 to 5 of 5

Return a value when target cell is non-blank

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2023
    Location
    London
    MS-Off Ver
    Latest Version
    Posts
    14

    Return a value when target cell is non-blank

    Hi hope you are well

    need an if formula to say that in Cell A1 is a heading called description and needs to be in bold
    if there is data in cell A3 then put data as a paragraph if not leave that cell and output blank

    need an if formula to say that in Cell B1 is a heading called ingredients and needs to be in bold
    if there is data in cell B3 then put data as a paragraph if not leave that cell and output blank

    need an if formula to say that in Cell C1 is a heading called size and needs to be in bold
    if there is data in cell C3 then put data as a paragraph if not leave that cell and output blank

    need an if formula to say that in Cell D1 is a heading called highlights and needs to be in bold
    if there is data in cell D3 then put data as a bullet point or unordered list if not leave that cell and check for data in cell E3 for the next bullet point if Cell D3 doesnt have any, vice versa

    Need an if formula also to say that in Cell G1 is a heading called Exclusion from free shipping and needs to be in bold
    if there is data in cell G3 then input data as a paragraph or output blank

    need all these formula one by one and all should work in html
    will put up a sheet for reference

    Thank you in advance
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 03-15-2023 at 07:48 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Improved Formula / i've run out room to extend the current formula / (avdanced code needed
    By pmw19800 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2018, 06:19 AM
  2. date formula help needed with blank cell and monthly assumtions formula needed
    By Michael.Howarth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2018, 07:47 AM
  3. Replies: 3
    Last Post: 04-06-2016, 12:19 PM
  4. Replies: 1
    Last Post: 01-11-2016, 02:31 PM
  5. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  6. [SOLVED] index formula needed--how to get a formula to skip columns
    By rsmidtisu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-02-2012, 11:22 AM
  7. Replies: 3
    Last Post: 09-07-2012, 12:07 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