Results 1 to 7 of 7

Logical formula in multiple criteria

Threaded View

amuljha Logical formula in multiple... 07-15-2017, 10:12 AM
Kaper Re: Logical formula in... 07-15-2017, 10:22 AM
amuljha Re: Logical formula in... 07-15-2017, 10:55 AM
tim201110 Re: Logical formula in... 07-15-2017, 10:27 AM
amuljha Re: Logical formula in... 07-15-2017, 10:57 AM
mehmetcik Re: Logical formula in... 07-15-2017, 10:27 AM
amuljha Re: Logical formula in... 07-15-2017, 10:59 AM
  1. #1
    Registered User
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2016
    Posts
    22

    Logical formula in multiple criteria

    Dear Moderators
    Many thanks for your support in providing the necessary help in constructing the automated files.

    I am in middle of constructing a formula please see the attached file:


    Need help in the following criteria:

    1 If E7 is "FD" then, the H7 can exceeds maximum limit of 80 then in cell I7 it should give result of only excess km will be there
    2 In the same way If E7 is "HD" then, the H7 exceeds maximum limit of 40 then in cell I7 it should give result of only excess km
    3 In the same way If E7 is "FD" then, the M7 can show the extra hrs if it is >8 hrs
    4 In the same way If E7 is "HD" then, the M7 can show the extra hrs if it is >4 hrs



    Appreciate you earliest help in this regards

    Amul
    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. Multiple Logical Formula
    By amuljha in forum Excel General
    Replies: 5
    Last Post: 07-05-2017, 02:49 PM
  2. Perform Logical Equivilent of Index Match Array look up with multiple criteria in VBA
    By MichaelDoughertyJr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-28-2016, 04:03 PM
  3. multiple criteria/logical tests required.
    By Imamu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-28-2013, 08:57 AM
  4. Multiple outcomes from a logical formula
    By JoeHan in forum Excel General
    Replies: 6
    Last Post: 05-24-2012, 05:54 PM
  5. Logical formula for multiple input
    By sagulolo in forum Excel General
    Replies: 4
    Last Post: 03-07-2012, 06:57 PM
  6. Logical Function for three criteria?
    By CardioGirl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-13-2006, 12:01 PM
  7. [SOLVED] Formula checking multiple worksheets:logical operator
    By sonic-the-mouse in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-06-2005, 02:05 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