round up round down formula

**m_789** · 04-04-2014, 04:37 AM

Morning guys,

I need a bit of help with the following..

So basically

A1 = £0.3667 - i need to display it as £0.3700 in B1
A2 = £0.3339 - i need to display it as £0.3300 in B2
A3 = £0.3315 - i need to display it as £0.3300 in B3
A4 = £0.0013 - i need to display it as £0.0100 in B4

What forumla can i use in b1 to do this?

**XOR LX** · 04-04-2014, 04:45 AM

Hi,

Your last result seems inconsistent with the rest. Why is it rounding up?

Regards

**m_789** · 04-04-2014, 04:50 AM

sorry the last one should ready £0.001

**XOR LX** · 04-04-2014, 04:52 AM

Now I'm really confused!

Surely you mean £0.01? If not, can you please explain your logic?

Regards

**[email protected]** · 04-04-2014, 05:02 AM

Try this
=ceiling(a1,0.01)

Regards,
Suhas

**m_789** · 04-04-2014, 05:27 AM

yes thats exactly what i mean sorry £0.01 confusing myself here

Originally Posted by XOR LX

Now I'm really confused!

Surely you mean £0.01? If not, can you please explain your logic?

Regards

**m_789** · 04-04-2014, 05:27 AM

so will appear as that basically

A1 = £0.3667 - i need to display it as £0.37 in B1
A2 = £0.3339 - i need to display it as £0.33 in B2
A3 = £0.3315 - i need to display it as £0.33 in B3
A4 = £0.0013 - i need to display it as £0.01 in B4

**XOR LX** · 04-04-2014, 05:34 AM

Sorry, but actually this still doesn't make sense. The first three are rounding to the nearest hundredth.

0.3667 rounds to 0.3700 since it is closer to 0.3700 than it is to 0.3600
0.3339 rounds to 0.3300 since it is closer to 0.3300 than it is to 0.3400
0.3315 rounds to 0.3300 since it is closer to 0.3300 than it is to 0.3400

So the last example, in order to be consistent, should be rounding to 0, since 0.0013 is closer to 0.0000 than it is to 0.0100.

Regards

round up round down formula

LinkBack

Thread Tools

Rate This Thread

Display

round up round down formula

Re: round up round down formula

Re: round up round down formula

Re: round up round down formula

Re: round up round down formula

Re: round up round down formula

Re: round up round down formula

Re: round up round down formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Conditional Round up or Round up Function

Counting to a specified numberin round, then add one to round

[SOLVED] Round down to nearest hour if # of hours is between HH:01 to HH:14, round up if # of hours

When ROUND doesnt round

[SOLVED] How do I ROUND() round off decimals of a column dataset?

Bookmarks

Bookmarks

Posting Permissions