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

I've just tried the formula you entered and it works fine. The #NAME? error happens when you type a formula name wrongly.

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)

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?

If I open the spreadsheet in Libre Office Calc, the cell shows #ADDIN? rather than #NAME? if that's any help