formula for rounding prices please

[wesleythorne]

Hi, I need a formula for rounding prices. In excel I need to change all my prices to not include decimal points as actinic only use 123
I have followed the help file but that does not work and actinic support is not worth the money as they carnt help ither.
I am really pissxx off with actinic, I have wasted two days trying to get vat to work and actinic just carnt cut it. There tehcnical support which I pay for is down right slow and unhelpful.

Wesley

[leehack]

An excel formula?

[Mike Hughes]

Round(number,0) rounds to the nearest whole number
Roundup(number,0) rounds up to the nearest whole number
Rounddown(number,0) rounds down to the nearest whole number

Mike

[Duncan Rounding]

I'm not sure exactly what you're asking but I'll have a stab...

I think you have two questions if I understand you correctly:
1. How do I round numbers to a specified number of digits?
The ROUND function in Excel will Round a value to the number of digits you specify.
2. How do I change my prices from decimal to integer.
If your price is for example 12.95 and you want it without decimals then you can just multipy by 100 in Excel. (Or use the ROUND function as above if you want the closest integer)