Results 1 to 20 of 20

multiple criteria for calculations

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    9

    multiple criteria for calculations

    I have a spreadsheet that I am trying to have automatically calculate a total based on certain criteria:
    I want the amount under the per diem amount column W to return a value based on if P is entered in column V. If this is for partial it will depend on departure and arrival times. If departure is after 6:00 AM no breakfast per diem is paid, if departure is after 11:00 AM no lunch is paid. If arrival is before 2:00 PM no lunch. If arrival is before 7:00 PM no dinner. If the user enters a 1 or 2 in column U, 1 uses out of state per diem breakdown located in cells I38:I40. In state uses a 2 and is located in cells E38:E40.

    Please Help
    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. How can I do calculations on multiple fields on multiple worksheets
    By rgreene in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2013, 11:01 AM
  2. [SOLVED] UDF for sum of multiple criteria in multiple columns and single criteria in multiple colum
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 11-22-2013, 04:26 AM
  3. How do I make specific calculations based on numerous criteria?
    By Harmse in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2013, 06:29 AM
  4. Multiple calculations in one SUMIF formula across multiple worksheets
    By necht_angel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-15-2011, 05:30 AM
  5. Doing multiple calculations.
    By berettagtz in forum Excel General
    Replies: 7
    Last Post: 04-11-2007, 01:42 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