Formula should work, but isnt. Text / Values / Hour challenge.
Results 1 to 3 of 3

Thread: Formula should work, but isnt. Text / Values / Hour challenge.

  1. #1
    Board Regular countryfan_nt's Avatar
    Join Date
    May 2004
    Location
    Saudi Arabia
    Posts
    653
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula should work, but isnt. Text / Values / Hour challenge.

    Hello friends, hope all is well!

    Please help me

    =IF(TEXT(INT($D3*24)-HOUR($C1),"0")=2,TRUE,FALSE) keeps giving me False.
    Even though the result of TEXT(INT($D3*24)-HOUR($C1),"0") gives me 2.

    Your kind help is needed and always appreciated in advance.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,113
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Formula should work, but isnt. Text / Values / Hour challenge.

    =(INT($D3*24)-HOUR($C1))&""

    should return a text result.
    Assuming too much and qualifying too much are two faces of the same problem.

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,897
    Post Thanks / Like
    Mentioned
    459 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Formula should work, but isnt. Text / Values / Hour challenge.

    Try putting quotes around the 2
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •