Excel help please

Discussion in 'Technical queries' started by flyer, 17 Dec 2018.

  1. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    902
    I'm using somebody else's spreadsheet and my Excel knowledge is pretty basic so keep it as simple as you can, ta

    Cell AB36 is a simple addition of hours worked, but it must always be rounded up (never down) to the nearest multiple of 24 in cell AB35. For example 16 should become 24, and 27 should become 48, and 59 should become 72 and so on.

    The formulae in AB35 is =IF(MROUND(AB36,24)<=AB36,MROUND(AB36,24)+24,MROUND(AB36,24))

    The only result I get in cell AB35 is #NAME?

    Anybody know how to put it right

    Thanks
     
  2. Prestwich_Blue

    Prestwich_Blue

    Joined:
    26 Jan 2006
    Messages:
    48,330
    Location:
    Wherever I lay my hat that's my home
    I've just tried the formula you entered and it works fine. The #NAME? error happens when you type a formula name wrongly.
     
  3. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    902
    Whats a formula name PB and how do I put it right?
     
  4. TonyM

    TonyM

    Joined:
    8 Aug 2006
    Messages:
    9,152
    Just guessing cos not got my computer nearby but does this work...

    =roundup((ab36/24),0)*24

    Eg ab36=12
    12/24=0.5
    Roundup=1
    Times 24=24

    If it works then you might also need an if error, so it could be...

    =iferror(roundup((ab36/24),0)*24),0)
     
  5. aguero93:20

    aguero93:20

    Joined:
    21 Oct 2013
    Messages:
    69,959
    Location:
    The Guardiola Circle Jerk
    Team supported:
    Team Pep
    IF is the formula name.
     
  6. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    902
    Thanks for the help all. I'll give it another go later this morning. Any further advise welcome
     
  7. Prestwich_Blue

    Prestwich_Blue

    Joined:
    26 Jan 2006
    Messages:
    48,330
    Location:
    Wherever I lay my hat that's my home
    It means there's something wrong in the formula itself, usually that you've misspelled the function or something. Did you do anything to it?
     
  8. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    902
    If I open the spreadsheet in Libre Office Calc, the cell shows #ADDIN? rather than #NAME? if that's any help
     
  9. aguero93:20

    aguero93:20

    Joined:
    21 Oct 2013
    Messages:
    69,959
    Location:
    The Guardiola Circle Jerk
    Team supported:
    Team Pep
    That means that you're using an add-on to excel that isn't compatible with libre afaik.
     
  10. DiscoSteve

    DiscoSteve

    Joined:
    30 Mar 2010
    Messages:
    7,549
    Location:
    201
    thought you were trying to use excel to work out Man United manager statistics
     

Share This Page