+ Reply to Thread
Results 1 to 5 of 5

if formula based on several criteria to extract data based on conditions

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,042

    if formula based on several criteria to extract data based on conditions

    I have a workbook that split qty based on criteria.

    That is if value of column AQ statistics value is either kg,u,m2,2u as criteria for formula in column Y ,qty1 header either to extract the qty in column w .

    but if the criteria is L in column AQ THEN take value of column N multiply value of column O, otherwise take the value of column W if the VALUE shown in column AQ are u,m2,2u . if kg is shown in column AQ , then do nothing.

    So far trying formula as below but need some adjustments

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JEAN1972; 12-17-2018 at 01:33 AM. Reason: Typo error

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,648

    Re: if formula based on several criteria to extract data based on conditions

    Please Login or Register  to view this content.
    is it column AW or Column AQ
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,042

    Re: if formula based on several criteria to extract data based on conditions

    Sorry it is column AQ instead of AW

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,648

    Re: if formula based on several criteria to extract data based on conditions

    TRY
    =IF(AQ2="L",IFERROR(1/(1/(N2*O2)),""),IF(OR(AQ2={"U","m2","2U"}),W2,""))
    If it not works, show your expected result and re attach the file

  5. #5
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,042

    Re: if formula based on several criteria to extract data based on conditions

    Thank you worked as requested

+ 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] formula based on 2 criteria to extract data
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-16-2018, 08:24 PM
  2. [SOLVED] complex if with index & match formula based on criteria in a column to extract data
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2018, 01:06 PM
  3. [SOLVED] Extract data based on table of conditions
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-06-2015, 01:32 PM
  4. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  5. Extract the data to another sheet based on variable conditions
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-25-2014, 06:10 PM
  6. Replies: 2
    Last Post: 06-01-2012, 09:24 AM
  7. Replies: 0
    Last Post: 01-12-2006, 04:20 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