Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Rounding up hours

  1. #11
    New Member
    Join Date
    Mar 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Ian but i really must clarify something here. To look in the Help files for the CEILING definition you need to knows it exists. I must admit that I had never even heard of it never mind what function it provided!

    Thanks for your explanation though it was very helpful

    Dave

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have to agree with that point. And I must add that to know each function well, that can take a while !

    I HAVE to believe that the Help file is getting better, at least that's what I "feel" (I don't use Excel's help a lot, only VBA's) it is, because in XP, Excel now asks "What do you want to do ?" and returns a list of possible functions.... as I said, I NEVER use this feature, but, it looks helpful !
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-28 10:27, daveray wrote:
    Leslie

    Your comments about thinking were most welcome. I have a fair understanding of Maths and number bases but I am dreadful at translating that into formulae that Excel understands. Unfortunately I know nothing about the CEILING function and my knowledge of Excel is limited to the basic functions.

    I am learning though through this board and your idea was excellent - thanks I always like the self help approach!

    Dave


    [ This Message was edited by: daveray on 2002-03-28 10:28 ]
    I must come back on this one, as to make the comment

    "...Unfortunately I know nothing about the CEILING function..."

    you must first have know that there was such a function.

    I agree with Juan's comments about the help files, XP also use the VBA style help which puts help 'Arguements' under the formula your typing.

    I do also agree that you need a lot of practice before you know even a small ammount of functions........but you did know that CEILING exsisted before asking.
    "Have a good time......all the time"
    Ian Mac

  4. #14
    New Member
    Join Date
    Mar 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I do also agree that you need a lot of practice before you know even a small ammount of functions........but you did know that CEILING exsisted before asking.
    Ian

    I think you have missed something. Go back and read my first post where I volunteered the TRUNC function that someone had passed onto me. As the posts progress, you will notice that a few people then kindly volunteered the CEILING function. That function was never mentioned by me prior to those posts and up until those posts I DID NOT KNOW ABOUT THE EXISTENCE OF THE CEILING function let alone what it did.

    Next in the list came the post from Leslie who applied some very helpful thinking strategy. In her post she ALSO mentioned CEILING along with Floor, average etc. I kindly thanked her and explained that I knew NOTHING about the CEILING function.

    You then very kindly posted a helpful explanation of the CEILING function and I also thanked you. In the meantime Thomas had fixed my problem and emailed the sheet back to me. I then didn’t need to read the help file as

    • My problem was solved
    • You had very kindly posted the help file.

    To reiterate my initial reply to Leslie - I knew nothing about CEILING prior to the very kind people on this board mentioning it to me.

    Once again I thank everyone for their kind help and that definitely includes you Ian for taking the time to point out my supposed error.

    Dave

Some videos you may like

User Tag List

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
  •