[SpikerzZ]

Hi, I want to know if there is a way to round a price to either $99.99 or $49.99?

For example, I want a computer price that is $1,069.82 to round down to $1,049.99 or one that is $1,042.65 to round down to $999.99, something like that, I have this formula to test with already.

=IF(I4=50,ROUNDUP(I4,0)-0.01,ROUNDDOWN(I4,0)-0.01)

That is just for the tests not actual numbers.

[Vicky Jorwal]

On Tuesday, December 22, 2015 at 12:19:05 AM UTC+5:30, SpikerzZ wrote:
Hi, I want to know if there is a way to round a price to either $99.99
or $49.99?

For example, I want a computer price that is $1,069.82 to round down to
$1,049.99 or one that is $1,042.65 to round down to $999.99, something
like that, I have this formula to test with already.

=IF(I4=50,ROUNDUP(I4,0)-0.01,ROUNDDOWN(I4,0)-0.01)

That is just for the tests not actual numbers.




--
SpikerzZ

Hi SpikerzZ,

Here is the very simple formula to use with your numbers, which will help you round these numbers according to your given condition.
it's FLOOR function, use it like this:
=FLOOR(50,0.9999)
this will give you $49.9995.

Regards,
Vicky