Results 1 to 24 of 24

Seeking helps to combine two formulas into one

Threaded View

  1. #1
    Registered User
    Join Date
    02-23-2021
    Location
    HK
    MS-Off Ver
    2013
    Posts
    69

    Seeking helps to combine two formulas into one

    I would like to seek someone's assistance to simplify and combine the two formulas below into one. Thanks

    Formula 1: =IF(COUNTIF($E$2:$E$4,TRUE)>1,"Incorrect Work Type",IF(COUNTIF($E$5:$E$6,TRUE)>1,"Incorrect Unit Rate & lowest Price",IF(AND($E$6=TRUE,$E$4=TRUE,$D$9="TWP"),"Standard",IF(AND($E$4=TRUE,$E$5=TRUE,$D$9="TWP"),"Lowest Price of Vendors",IF(AND($E$2=TRUE,$E$6=TRUE),"Westco",IF(OR(AND($E$4=TRUE,$E$5=TRUE),AND($E$2=TRUE,$E$5=TRUE)),"Lowest Price of Vendors","Incorrect or Other Vendors"))))))


    Formula 2: =IF(C9=G8,"Correct","Check Vendors")
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combine 12 IF formulas into 1
    By kyle4570 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2022, 10:02 PM
  2. Seeking Advice Regarding Formulas for Rebate Template
    By Tsg295 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2020, 12:07 PM
  3. [SOLVED] Need help to combine two formulas
    By jhudson444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2016, 04:40 PM
  4. [SOLVED] Seeking formulas tor Billing Statement to calculate Past Due 30, 60, 90, 120 days
    By ElmerFud in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-30-2015, 02:47 PM
  5. [SOLVED] How to combine four formulas into one?
    By JohnJK04 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-31-2015, 07:13 PM
  6. seeking a summary table using only formulas
    By James C in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2013, 05:21 PM
  7. [SOLVED] Using Combine macro to combine multiple worksheets - need to modify to paste formulas
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 09: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