Results 1 to 5 of 5

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

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,143

    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

    =IF(OR(AQ2="L",AQ2="kg"),IFERROR(1/(1/(N2*O2)),""),IF(OR(AQ2={"U","m2","m","2U"}),0,""))
    Attached Files Attached Files
    Last edited by JEAN1972; 12-17-2018 at 01:33 AM. Reason: Typo error

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