In Excel if you need to round up to the next whole number in a formula - how do you do it?

[KatyMac]

so 22/8 = 2.75 I want it to say 3; the formula looks like this

(((a1/8)-2)*31)=???

You're welcome! And I didn't take your post as rude, just frustrated!!!

Have you ever used the function wizard in excel? It's the fx button. It helps explain what you need to put in each bit of the function. It can be quite useful.

I think that's what got me into the mess

I'm now on table of contents in word

I need gaps between the entries

I'll bow out at this point, I find word very frustrating!!!

Although have you tried right clicking on the table of contents and seeing if there is a format option?

Nope I'm back on excel

Is this
=MAX(ROUNDUP(((C4/8)-2)*Wage,0),0)

Different to this
=MAX(ROUNDUP((C6/4)*Wage,0),0)

Because the first one works & the second doesn't

Format the paragraph style of the T1, T2 etc...contents entries so they have a 6 or 12 PT gap (you may be able to do this just by editing the paragraph style and see if it auto updates, or go into Styles)

Now =MAX((ROUNDUP(C6/4,0)*Wage)) works

Thanks Himalaya - I think I got that after your advise yesterday (it was you wasn't it? ) - btw sent you a message (I think - feeling a bit dippy atm)

Sorted the Excel, sorted the table of contents

Thanks everyone