Help I need help with "ROUNDUP" in Excell??

[Katymac]

OK - I rounded up 1.33 to 2

But if I do a conditional format it still uses 1.33 rather than 2

Is there a way round this?

It worked for me.

How is your spreadsheet laid out?

Tried it again.

1.33 in A1

=ROUNDUP(A1,0) in B1. (Shows '2', as expected)

=IF($B$1>=2,TRUE,FALSE) in C1.

C1 shows True, so your conditional format should work. How weird...

it says

=ROUNDUP((BK3/3),0)

Is that wrong?

What is the conditional formatting trying to highlight - numbers over 2? Are the original number and the rounded-up number in different columns, or have you rounded within the cell, eg =ROUNDUP(1.33,0)?

It should be working.

E.g.

I put 4 in cell C4.
In cell B2 I have =ROUNDUP((C2/3),0)
Then on B2 have Format -> Conditional Formatting and set background to green if Cell Value is greater than or equal to 2.
It sets the background to green, with no problems.

What do you have in Conditional Formatting?

Oh I'm completely confused

I think I'll keep looking at it - to see if I understand it

Thanks for trying