Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Round dollars
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round dollars
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Live Currency Conversion US Dollars to Australian Dollars | Excel Discussion (Misc queries) | |||
How to round values from formulas to whole dollars | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions | |||
converting #dollars into word dollars? | Excel Worksheet Functions |