Advertisement

loader

Talk

Advanced search

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

(7 Posts)
Katymac Fri 22-Jun-07 15:17:01

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?

Kevlarhead Fri 22-Jun-07 18:54:27

It worked for me.

How is your spreadsheet laid out?

Kevlarhead Fri 22-Jun-07 19:01:46

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...

Katymac Fri 22-Jun-07 19:19:58

it says

=ROUNDUP((BK3/3),0)

Is that wrong?

AlienEars Fri 22-Jun-07 19:33:05

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)?

lemonaid Fri 22-Jun-07 19:37:12

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?

Katymac Fri 22-Jun-07 19:52:16

Oh I'm completely confused

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

Thanks for trying

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now