+ Reply to Thread
Results 1 to 5 of 5

Need to add IF condition

  1. #1
    Forum Contributor
    Join Date
    07-15-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    116

    Need to add IF condition

    Hi Guys,

    I'm using this formula in attendance sheet & need to add a condition.

    =H8+I8/60+K8

    I want K8 to be added in the end only if H8 value is greater than 11

    Someone please help.

    Regards
    Andy
    Last edited by andyzz; 07-17-2014 at 09:11 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Need to add IF condition

    Hi

    Try this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If this solves your problem, please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanks

  3. #3
    Forum Contributor
    Join Date
    07-15-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    116

    Re: Need to add IF condition

    Thanks a lot, it worked! Great

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Need to add IF condition

    No worries. Please don't forget to click on the * next to my post to say thanks

  5. #5
    Forum Contributor
    Join Date
    07-15-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    116

    Re: Need to add IF condition

    I'm unable to see any thanks button but I've added to reputation. thnx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF the condition of gender is met AND the condition of age is met subtract this number
    By arsenalmom in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-16-2014, 11:16 PM
  2. [SOLVED] Help for if condition formula result only either hit or miss from mulitple condition
    By breadwinner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 07:29 AM
  3. Replies: 6
    Last Post: 05-06-2010, 10:06 PM
  4. Running an if condition looped with another if condition in VBA
    By anuj.agarwal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2010, 08:12 PM
  5. multi condition format? lookup and date condition valid for.
    By D_Rennie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2009, 11:37 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