Results 1 to 6 of 6

Formula help - multiple conditions for IF function

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2016
    Location
    Brisbane, Austalia
    MS-Off Ver
    2013
    Posts
    2

    Wink Formula help - multiple conditions for IF function

    Hi
    I have a spreadsheet that is updated daily, it is used to track hours/kms of trucks and when the last service was completed.

    I need a formula added into column G (HRS truck service due) that will do the following
    - if column E "Last service type" equals "A", add D2(HR's/KMs till truck service due)+250
    - if column E is "B", add D2+125
    - if column E is "C", add D2+125

    For example in the attached worksheet G2 will equal 29,398. I want a formula that will add these values automatically. I did try the IF function (and nesting IF Functions) and I don't think it was correct

    Thank you!
    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 conditions which function to use
    By bbis21 in forum Excel General
    Replies: 7
    Last Post: 11-20-2014, 09:42 PM
  2. MID Function with multiple conditions.
    By kaminanirav in forum Excel General
    Replies: 8
    Last Post: 08-28-2014, 11:56 AM
  3. [SOLVED] IF Function with multiple conditions
    By Rob.Marchel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2014, 01:27 AM
  4. [SOLVED] IF function help, multiple conditions
    By wantucce in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-20-2014, 12:22 PM
  5. [SOLVED] IF function with multiple conditions
    By nicko54 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2013, 01:51 AM
  6. Multiple conditions for if function
    By jiyan200 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2012, 11:12 AM
  7. Looking for a function for multiple conditions
    By MrSales in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2007, 03:27 PM

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