Results 1 to 6 of 6

Extract details based on If formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,776

    Extract details based on If formula

    I have a sheet called "Data"


    I have tried to set up a formula on sheet 'Email Body"



    Where there is zero in cell C1 on sheet "Data" then formula to return "No salary changes" . Where C1 <>0, then extract non-blank range from A2 to C20


    It would be appreciated if someome could amend my formula on sheet "Email Body"

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] NEED THE DETAILS TO PICK FROM a column based on the details available in another sheet
    By anuwers in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2020, 03:35 AM
  2. Formula to fetch details based on criteria.
    By saravanan1981 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2020, 04:40 AM
  3. [SOLVED] Extract report details
    By Shamz41 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2017, 12:13 AM
  4. [SOLVED] Extract the details from PDF to Excel
    By mvinay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2013, 02:38 PM
  5. Extract details form code with formula
    By freud1 in forum Excel General
    Replies: 3
    Last Post: 07-13-2012, 06:45 AM
  6. [SOLVED] Formula to lookup details based on name
    By Smamfa1971 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-02-2012, 09:21 AM
  7. extract hyperlinks/details
    By afgi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2010, 03:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1