+ Reply to Thread
Results 1 to 4 of 4

If Elseif elseif problem

Hybrid View

tjbillund If Elseif elseif problem 08-10-2011, 05:56 AM
estige Re: If Elseif elseif problem 08-10-2011, 06:06 AM
tjbillund Re: If Elseif elseif problem 08-10-2011, 07:02 AM
tarquinious Re: If Elseif elseif problem 08-10-2011, 06:58 AM
  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    4

    If Elseif elseif problem

    Hi

    Im new to this and hope some of u guys/girls can help me.
    i have some fields
    D7=Starttid (format time)
    D8=Sluttid (format time)
    D9=Ferie (format decimal)
    D10=Hour

    What i have now is that D10=:
    =IF([@Starttid]="";[@[Ferie]])
    It say that if D7 is blank then D10=D9, that work, but what i want to do is something like this.
    =IF((([@Sluttid]-[@Starttid])*24);IF([@Starttid]="";[@[Ferie]]))
    but i cant get it to work.

    What i need it to is:
    If D7=blank then D10=D9 else D10= (D8 - D7)*24

    can someone help me with a formel that can fix my problem !?

  2. #2
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: If Elseif elseif problem

    Maybe (in D10):
    =HVIS(D7="";D9;(D8-D7)*24)

  3. #3
    Registered User
    Join Date
    08-10-2011
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: If Elseif elseif problem

    so easy....thx.

  4. #4
    Registered User
    Join Date
    05-13-2011
    Location
    New Zealander in London
    MS-Off Ver
    Excel 2007
    Posts
    74

    Re: If Elseif elseif problem

    And in English Excel - in D10:
    =IF(D7="",D9,(D8-D7)*24)

+ 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