Announcements
cancel
Showing results for
Did you mean:
Creator

## Compare rounded numbers

Hi

I'm doing a calculation in a table that I want to compare to another calculation.  Both calculations result in a decimal number.

Is it possible to compare the rounded whole number of each?

Basically in the first calculation, I'm getting 10.44 which when rounded gives me 10.

In the second calculation, I'm getting 9.63 which when rounded also gives me 10.

I want to colour condition the field so that if the first calculation (rounded) equals the second calculation(rounded) then highlight in green.

I've searched around but can't quite find what I'm looking for.

I've tried rounding each calculation, I've tried the Ceil function (but realise this is not what I need) and I've tried the num function.

Thanks for any help.

Ciara

3 Replies

Try Round()

``````Round(10.44)=10
Round(9.63)=10
Round(9.33)=9``````
Creator
Author

Hi Saran

The round function actually did work eventually.  I had my parentheses in the wrong place.

Ciara

MVP

Try this