permalink for this thread : http://search.catflaporama.com/post/browse/529757634
Buddy Posted on 14/3 16:31
Excel Mobile query

Excel Mobile doesn't appear to recognise the command ROUNDUP. Anyone know of a way around this?

ThePrisoner Posted on 14/3 16:41
re: Excel Mobile query

You could use the INT and IF functions to achieve the same thing (if Excel recognises INT and IF functions on your machine)

e.g.

If you have a number x

If(x-INT(x)>=0.5,x+1,x)

If x is 20.7 then INT(20.7)=20
20.7-20 = 0.7
Therefore Cell value = 20+1=21

Or summat.

Buddy Posted on 15/3 8:36
re: Excel Mobile query

Thank you Prisoner, that sorted it nicely.

The actual formula you put up there I could have coped with using ROUND - which Excel Mobile can do - what I was after was to make anything a fraction above x return x+1. By changing 0.5 in your formula to 0.001 I now have a nice concise little formula, using a function I'd not heard of before.

Ta.