Results 1 to 9 of 9

If and or query (Office 365 - Latest Excel)

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2022
    Location
    Cheshire
    MS-Off Ver
    11
    Posts
    4

    If and or query (Office 365 - Latest Excel)

    Hi All

    Tried my best to solve this with no joy wondering if someone could help me solve this - please.

    IF CELL B24 is 500000 and less than 750000 and Cell B28 is >2.25 return "FAIL" if not "PASS",
    and IF CELL B24 is 750000 and less than 10000000 and Cell B28 is >2.5 return "FAIL" if not "PASS"
    and IF CELL B24 is 1000000 or > and Cell B28 is >3 return "FAIL" if not "PASS"
    Last edited by Robert Hulse; 05-20-2022 at 01:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Power Query Refresh or Access Query - 2nd Query Run is faster
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2020, 10:16 AM
  2. Refresh all Power Query Pivots performing only 1 Query and stops
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2019, 04:49 AM
  3. Replies: 0
    Last Post: 03-22-2016, 05:14 PM
  4. Replies: 1
    Last Post: 09-08-2015, 08:12 PM
  5. Replies: 2
    Last Post: 02-01-2013, 04:21 PM
  6. Problem with selecting range with in query table after query refresh
    By shooter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 11:55 AM
  7. Web Query - Change a word in query to form a new query
    By scottymelloty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2011, 04:13 AM

Tags for this Thread

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