Excel help please

[flyer]

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

 

[Prestwich_Blue]

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

 

[flyer]

Whats a formula name PB and how do I put it right?

 

[TonyM]

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)

 

[aguero93:20]

Whats a formula name PB and how do I put it right?

IF is the formula name.

 

[flyer]

Thanks for the help all. I'll give it another go later this morning. Any further advise welcome

 

[Prestwich_Blue]

Whats a formula name PB and how do I put it right?

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?

 

[flyer]

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

 

[aguero93:20]

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

That means that you're using an add-on to excel that isn't compatible with libre afaik.

 

[DiscoSteve]

thought you were trying to use excel to work out Man United manager statistics