+ Reply to Thread
Results 1 to 4 of 4

Formula with statement

  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Microsoft 365
    Posts
    327

    Formula with statement

    Hi All, I have this formula in cell G11 - =IF(b3="","",(G2+E3-F3)), how can I add a statement to this formula in G11? If G11 contains more than 40hrs, I want a statement that shows "You have more than 40hrs".

    I tried what I could - nothing worked.

    Any suggestions?

    Thanx...Ltat42a

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    =IF(B3="","",IF((G2+E3-F3)>40,"You have more than 40 hrs",(G2+E3-F3)))
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

  3. #3
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Microsoft 365
    Posts
    327
    Quote Originally Posted by WinteE
    =IF(B3="","",IF((G2+E3-F3)>40,"You have more than 40 hrs",(G2+E3-F3)))
    Ah man....I was so close, Thanx!

  4. #4
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    You're welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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