Formatting numbers with decimals

[deemer98]

I pull data from two different websites and I need to verify each are correct. One site gives me a weight with no decimals (15, 551), the other website gives decimals to three positions (15,550.764)

I have a verification sheet set up with conditional formatting to recognize duplicate values within a column. Obviously it won't recognize the two numbers above as duplicates.

I tried dropping the decimals in the formatting of the cells, but when I copy and paste it into my verification sheet, it pastes as the original number with the numbers after the decimals.

Is there a way to format the cells so that it automatically rounds up for anything .500 and higher or rounds down for .499 and lower?

Hope that didn't confuse anyone. Thanks!

David

 

[Rick Rothstein]

Formatting a cell does not change the underlying value in a cell... it only changes how that value is displayed. If you need to round a value for comparison, use the ROUND function in you formula directly.

 

[deemer98]

Can I use ROUNDUP and ROUNDDOWN in the same cell? If so, how would that look?

 

[Rick Rothstein]

If I understand what you want to do correctly, the ROUND function will do both the round up and round down for you automatically.

 

[deemer98]

If I understand what you want to do correctly, the ROUND function will do both the round up and round down for you automatically.

Good to go Rick! Thanks!