Results 1 to 9 of 9

Multiple "IF" formula with "OR" conditions (or a better way?)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-06-2007
    Posts
    123

    Multiple "IF" formula with "OR" conditions (or a better way?)

    Hi

    I am trying to workout bonus entitlements for various departments based on performance ratings where some departments will get a different entitlement on their score.

    I attach an example of what I am trying to do i.e. All departments get a bonus for 4 and 5 ratings but the Defence projects get an additional "extra bonus" for a 5. Only North and South get it for a 3 and nothing for all for 2 and below.

    Thank you

    Regards

    Cortlyn
    Attached Files Attached Files
    Last edited by Cortlyn; 03-05-2014 at 12:23 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  3. Defining logic "Yes" or "No" , based on multiple conditions
    By pyol17 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 02:41 AM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. Replies: 7
    Last Post: 05-13-2006, 05:02 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